Macro to combine cells data based on same values

Hi,

I like this forum....It is very usefull for excel and excel programmers.

Thanks for your help "Excel Forum".

Again i need a help on macro for below.

In A and B columns i have a data like this.
A B
===== ==========
Name1 Streamx
Name2 Streamy
Name3 Streamz
Name4 Stream1
Name1 Stream2
Name3 StreamW

The above have to display like below.

A B
===== ========
Name1 Streamx/ Stream2
Name2 Streamy
Name3 Streamz/ StreamW
Name4 Stream1


Could you please help me out.

Thanks,
Spice

Hi spice,
A quick forum search and you cant find most problems already answered
try ..

Please Login or Register  to view this content.