Hi,

Try this:

Select Table 1 and convert it to a Table (Ctrl+T) - please ensure that the
"This table has headers" box is unchecked. Now assign it a name, say
Range1. Now do the same for Table2 - convert it to a table and assign it a
name, say Range2

Now save the file on the desktop. While on any blank cell, go to Data
From Other Sources From Microsoft Query. Select Excel files and click on
OK. In the Select Workbook window, select the file which you just saved on
the desktop and click on OK. On the left had side box, you will see the two
names which you had assigned - Table1 and Table2. Select Table1 and click
on the right arrow - do the same for Table2 (All the columns of the two
tables will appear in the RHS box). Now click on Next. You will get a
message box saying that the Query Wizard cannot continue. Click on OK. You
will now see the output you want (nearly). You may now click on any 1 entry
in the duplicated column and then go to Records Remove column. Now
arrange the columns the way you like and go to File Return Data to
Microsoft Office Excel. Click on Properties and check the box for refresh
every 1 minute. Also check the box for Refresh when opening the file.
Click on OK and select the cell where you want the output. Click on OK.

You will now get your desired output.

Hope this helps.


--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cheekyaardvark" wrote in message
...
So if we go with the above example & say that it was a static 2 way
split how would we get the merge to happen?

0300809 01 03 00006707 015
0300809 01 03 00008116 085

0300809 00012043
0300809 00012077

to get this
0300809 00012043 01 03 00006707 015
0300809 00012043 01 03 00008116 085
0300809 00012077 01 03 00006707 015
0300809 00012077 01 03 00008116 085

Is that now relatively straightforward

Thanks for all the help BTW