thanks for the response special K, but unfortunately thats not what im
looking to do. I guess I wasnt clear. I have two sets of data merged
into one spreadsheet, but with similar ID#, I am trying to match the
ID# together so if this is what is in my columns:

F01B 31/14 2066196 2066196 123353
C12N 15/16 2066197 2066196 1051593
C03C 17/34 2066198 2066197 124452
D01F 9/12 2066199 2066198 124454
D04H 1/70 2066200 2066199 123449
G07D 7/00 2066201 2066200 990031
G11B 7/00 2066202 2066201 124455
C07D 209/48 2066203 2066202 1160521
C12N 15/12 2066204 2066203 124456
C07C 2/66 2066205 2066203 1052512


I somehow want to match the 2 columns so that they look like this:

F01B 31/14 2066196 2066196 123353
2066196 1051593
C12N 15/16 2066197 2066197 124452
C03C 17/34 2066198 2066198 124454
D01F 9/12 2066199 2066199 123449
D04H 1/70 2066200 2066200 990031
G07D 7/00 2066201 2066201 124455
G11B 7/00 2066202 2066202 1160521
C07D 209/48 2066203 2066203 124456
2066203 1052512
C12N 15/12 2066204 2066204 103124

Hopefully this is a little more clear. I have 440,000 cells of this
stuff (like 13 spreadsheets) so if anyone could help me with this, your
help would be much aprreciated! As it would take me a month to do it the
way im doing it now.

Thanks.


--
c0nfusEd :{
------------------------------------------------------------------------
c0nfusEd :{'s Profile: http://www.excelforum.com/member.php...o&userid=36327
View this thread: http://www.excelforum.com/showthread...hreadid=561103