Forum Discussion
Solved
How do I make more rows after each ,
Hi Power BI community
I have a table with leader ids. Sometimes a row has a single id and othertimes it multiple ids split by ","
Like this.
I want to add a new row each time I have a "," so no row has more than a single number.
Is this possible?
split column by delimiter, using "," as delimeter. Click the 'To rows' option
4 Replies
split column by delimiter, using "," as delimeter. Click the 'To rows' option
Thanks HotChilli
Your solution was super easy to impliment and worked like a charm.
ThomasWeppler add a new column with Text.Split([Column],',') and then exapnd to new rows
