Forum Discussion
Separate Data
Hello,
I'd like to seperate my data like the attached picture shows.
Basically, there can be as many indicators as you like. It should only be separated, which contain two or more. The information from all other columns should be taken over without change. How could I solve this?
Thank you :)
3 Replies
In Transform option, choose Split Column option and choose Split into Rows option
In Power Query.
Split the column using ',' as separator .
Select the new columns and choose 'Unpivot columns' on the Transpose menu.
Tidy up your columns aand data as required (remove unwanted columns, trim spaces etc)
