Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
2 years ago
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 ...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

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

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
2 years ago

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

  • ThomasWeppler's avatar
    ThomasWeppler
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

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