Excel VBA merge similar rows

[jelsberry]

I have an excel spreadsheet and it has columns "emp id", "emp", and "products"
now there are multiple records for each emp ids but different products, i want to make it so that there is only one row per emp id so i need to combine the products for each emp id. For example:

original:

emp id emp products
------ ------------ ----------
1 Bobs Plumbing wrench
1 Bobs Plumbing pipe

desired:

emp id emp products
------ ------------ ----------
1 Bobs Plumbing wrench, pipe

Any ideas??

Any help is appreciated

 

[PHV]

And what about a pivot table ?

Hope This Help
PH.