Forum Discussion

Robbief's avatar
Robbief
Helper II
4 years ago
Solved

Comma Separated Data expanded to new rows (M Query)

I'm not sure what to even search for relating to this query (Usually my Google is strong, but I'm not winning today)....

 

I have some data formatted like so:

 

I want to expand the comma seperated tags into a new expanded table (Leaving the existing Table if possible) that results as follows:

 

What would be the steps you recomend I need to follow in order to achieve this?  

 

Thanks in advance!

  • I think it'd be easier to use the split to rows option...