Split rows base on value

Hi Team ,

I'm looking for a tools to split my data set accordingly. The original data like below
Example :

Input : A001 Day 4 and B001 Day 1,3,6

Output:

A001, Day 4
B001 , Day 1
B001 ,Day 3
B001, Day 6

Help

Accepted answers

Try text to columns ( space delimiter) followed by another text to columns ( , delimiter and split to rows ) .

You could use regex something like:

(\w\d+\s)Day\s(\d+)\sand\s(\w\d+\s)Day\s(\d+),(\d+),(\d+)

parse it to several columns

Hi @kflow I also used RegEx, but broke it into a couple of steps:

Does your data really come in the form "A001 Day 4 and B001 Day 1,3,6"? What if you get a record for C001? Does it add an "and".

Could it actually come in on separate rows like

A001 Day 4

B001 Day 1,3,6

Dan

hi@danilang,

The original data is like below:

A001 Day 4

B001 Day 1,3,6

Try text to columns ( space delimiter) followed by another text to columns ( , delimiter and split to rows ) .

Thanks for your help, i'm able to do what i want with the simple flow.