Copying Data Seperated by Commas

russdyer

New Member
Joined
Mar 19, 2008
Messages
22
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
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,123,268
Messages
5,600,620
Members
414,394
Latest member
mahendar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top