Really struggling with this one!
I have a data set from a client that has allergen information in one of the columns. For example Contains Milk, May Contain Wheat etc etc. The issue is that if a product contains more than one allergen they have been listed in the same cell but what looks like a new line within the same cell. I eventually need to break these out into 14 columns (one column for each of the 14 major allergens) Im planning to do a delimited text to column once I can get a delimiter character in place, thats where I fall down!
I have attached a sample from my extract in hope it would aid someone to be able to offer some guidance.