Howdy,
I have Column A in Sheet1 that contains semi-colon delimited strings (of brands) in a big list, and Column A in Sheet2 which contains a list of all possible brands, and next to them in Column B the corresponding category of the brands.
(with 7 possible categories: Fragrance, Make Up, Skin Care, Sun & Tanning, Bath & Body, Hair, Gifts)
i.e.
Brand1; Brand2; Brand4
Brand1; Brand3;
and in the next sheet
Brand1 | Fragrance
Brand2 | Fragrance
Brand3 | Make Up
Brand4 | Sun & Tanning
etc.
I need to determine what categories are within the delimited lists in Column A in Sheet1. I imagined the best way to do this is to have 6 columns in Sheet1 with headers of the categories, and then 1 in the row of the string which contains a brand of that category.
i.e.
Kind of obtuse. Does this make sense? Is there a better way of doing this?
################Fragrance| Make Up| Skin Care| Sun & Tanning| Bath & Body| Hair| Gifts
Brand1; Brand2; Brand3;|1|1|0|0|0|0
Brand1; Brand4;|1|0|0|1|0|0
Any questions and I'm happy to elaborate or provide a sample worksheet.
Thank you for very much in advance for your attention and effort!
Bookmarks