Forum Discussion
ThomasWeppler
2 years agoImpactful Individual
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 ...
- 2 years ago
split column by delimiter, using "," as delimeter. Click the 'To rows' option
smpa01
2 years agoCommunity Champion
ThomasWeppler add a new column with Text.Split([Column],',') and then exapnd to new rows
- ThomasWeppler2 years agoImpactful Individual
Thanks smpa01
I wnet with HotChilli solution, but I am sure your solution would have worked as well 🙂