1
I have two 'tabs' in my Excel file and I would like to merge the two tabs into one sheet (in the same file).
The two files look somthing like:
artnr language description price
artnr language description price
artnr language description price
What I would like to do is merge those two files in the following manner:
first row of first sheet
first row of second sheet
second row of first sheet
second row of second sheet
etc.
I tried to use the following formula:
=Sheet1!A1
=Sheet2!A1
=Sheet1!A2
=Sheet2!A2
This works, however when I try to expand the formula down (to the other rows) I get:
=Sheet1!A1
=Sheet2!A1
=Sheet1!A2
=Sheet2!A2
=Sheet1!A5
=Sheet2!A5
In stead of:
=Sheet1!A1
=Sheet2!A1
=Sheet1!A2
=Sheet2!A2
=Sheet1!A3
=Sheet2!A3
Any help is appreciated!
Now that's a simple and working solution! Thanks! – PeeHaa – 2010-12-28T13:47:46.477
Glad I could help. – Reuben L. – 2010-12-28T13:59:45.530