Splitting comma separated values in a field into multiple rows

ccostello

Hi all!

Hoping someone can help.

Please see below sample data:

Drink	Card or Cash	Price
Coffee, Tea, Coke	Card	80p
Coffee	Cash	80p
Coffee	Card	80p
Tea, Coke	Card	80p

I want to separate out the comma separated values into separate rows but keep the data in all other columns. I would want the above to look like the below:

Drink	Card or Cash	Price
Coffee	Card	80p
Tea	Card	80p
Coke	Card	80p
Coffee	Cash	80p
Coffee	Card	80p
Tea	Card	80p
Coke	Card	80p

What is the best way to do this please?

Please note also within the same data set have the same issue where some values are separated by '/'

Thanks so much!

Blake

Hi @ccostello 

Use the text to columns tool but select "split to rows"

Although my screenshot doesn't show it, you can toss both delimiters in the tool. 

See the attached example and please mark this as solved if it accomplishes what you are trying to do.

split to rows.yxmd