Forum Discussion
Solved
How do I duplicate rows based on cell contents (cell contains semi-colon seperated data)?
How do I duplicate rows based on the content of Column B. I'd like a separate row for each "Person" in the cell? This is my starting table (I can't extract the data in any other way): ...
HI h0ttamale,
This could be done by Query Editor (M Language) as below steps:
- Click Edit Queries
- In Query Editor, Choose Add Column tab -> Choose Custom Column
- Name for new column: NewContact with formula: Text.Split([Contact],";")
- In the top right of NewContact column, choose Expand to new rows
If this works for you please accept it as solution and also like to give KUDOS.
Best regards
Tri Nguyen
HI h0ttamale,
This could be done by Query Editor (M Language) as below steps:
- Click Edit Queries
- In Query Editor, Choose Add Column tab -> Choose Custom Column
- Name for new column: NewContact with formula: Text.Split([Contact],";")
- In the top right of NewContact column, choose Expand to new rows
If this works for you please accept it as solution and also like to give KUDOS.
Best regards
Tri Nguyen
Awesome! Thanks! Works perfectly.