you could write a simple macro that checks each cell in col 1 and col 2

eg if a2=a1 then delete a2

apples GREEN TYPE1 10
apples GREEN TYPE2 12
pears GREEN TYPE2 30

becomes

apples GREEN TYPE1 10
TYPE2 12
pears GREEN TYPE2 30


Then you could concatenate A1,B1,C1,D1
A2,B2,C2,D2 ETC ETC

AND PUT THE RESULT IN ONE CELL IF YOU DESIRE

A B C D E
TYPE2 10 TYPE2 10


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=527096