Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Robbief
Helper II
Helper II

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:

Robbief_0-1659371987431.png

 

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

Robbief_1-1659372069150.png

 

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

 

Thanks in advance!

1 ACCEPTED SOLUTION
KNP
Super User
Super User

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

KNP_0-1659378700214.gif

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

View solution in original post

2 REPLIES 2
KNP
Super User
Super User

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

KNP_0-1659378700214.gif

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Robbief
Helper II
Helper II

I solved this thanks to this video......   https://www.youtube.com/watch?v=pH6W5dmX8h0

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors