Copying Data Seperated by Commas

[russdyer]

I have a list of products where each product belongs to multiple categories. The product is listed in colA and the categories are listed in colB. So here is an example:

ColA--------ColB
Potted Plant Plant, Potted, Round, Dirt

Is there a forumula/macro that can take colB and copy each Category into Columns C-F that are seperated by commas? Also, some products may belong to more than 4 categories, sometimes up to 10.

Also, is there then a way to get that range of categories collected by 300+ products to create one list of categories without duplicates?

Thank you for any help you can give me.

Russ

 

[seenfresh]

For both questions go to your Menu Bar and select "Data" then from your Tools Bar select "Text to Columns" and "Remove Duplicates".... follow the directions for each and they should take care of each of your tasks...

Text to Columns:

http://office.microsoft.com/en-us/excel/HA011498511033.aspx

Remove Duplicates:

http://office.microsoft.com/en-us/excel/HP100739431033.aspx

 

[russdyer]

Thank you so much!