Separate Data

[Nilson]

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 🙂 

[Anonymous · Accepted solution]

Hi 

1. First click on Data column and go split option.

2. Go through split Column options.

3. Click On advanced options and select Rows options only.

4. Click on Ok 

regards,

naveen

[meet2aftab]

In Transform option, choose Split Column option and choose Split into Rows option

[HotChilli]

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)