How do I make more rows after each ,

[ThomasWeppler]

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?

[smpa01]

@ThomasWeppler add a new column with Text.Split([Column],',') and then exapnd to new rows

[ThomasWeppler]

Thanks @smpa01 
I wnet with @HotChilli  solution, but I am sure your solution would have worked as well 🙂

[HotChilli · Accepted solution]

split column by delimiter, using ","  as delimeter. Click the 'To rows' option

[ThomasWeppler]

Thanks @HotChilli 
Your solution was super easy to impliment and worked like a charm.