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!