I'm stumped as to how to do this. I've tried several approaches but my
Excel skills aren't quite there I guess.

Here's what I'm trying to do...data is setup in columns Like below:

A B
EMP ID CUST ID
001 AAA
001 BBB
001 CCC
002 DDD
003 EEE
003 FFF
004 GGG

I'm trying to search the data for matches, and have it appear in rows
like this:

A B C D
EMP ID
001 AAA BBB CCC
002 DDD
003 EEE FFF
004 GGG


Any suggestions are greatly appreciated!


--
couriced
------------------------------------------------------------------------
couriced's Profile: http://www.excelforum.com/member.php...o&userid=26900
View this thread: http://www.excelforum.com/showthread...hreadid=471533