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
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