Find duplicates and append
 

Hi one and all

Want to do a look for duplicate and if yes then append data.

Example

Column 1 Column 2
1234 product1
1234 product 2
1234 product 3

i would like it find where column 1 contains a duplicate then if yes
append the data or copy it into column 2, and 3 and 4

Column 1 Column 2 Column 3 Column 4
1234 product1 product 2 product 3
1234 product 2
1234 product 3


Possible?


Thanks

If possible also to mark in column 5 as a dup like this


Column 1 Column 2 Column 3 Column 4 Column 5
1234 product1 product 2 product 3
1234 product 2 Dup
1234 product 3 Dup


--
HUBBUB88
------------------------------------------------------------------------
HUBBUB88's Profile: http://www.excelforum.com/member.php...o&userid=24416
View this thread: http://www.excelforum.com/showthread...hreadid=474834