Hi All

Need some urgent help

i have worksheet with the following format

1111 abc
1111 xyz
1234 qwe

I need help to merge column b values depending on column A.If two rows
have the same value in column a then i would like to merge column b as
shown below.
So i need the above data to appear as

1111 abc,xyz
1234 qwe

thanks
sp123


--
sp123
------------------------------------------------------------------------
sp123's Profile: http://www.excelforum.com/member.php...o&userid=31163
View this thread: http://www.excelforum.com/showthread...hreadid=521943