Reply
avatar user
Anonymous
Not applicable

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 🙂 

 

000010.jpg

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Hi 

 

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

 

Capture.JPG

 

2. Go through split Column options.

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

 

Capture1.JPG

4. Click on Ok 

Capture2.JPG

 

regards,

naveen

View solution in original post

3 REPLIES 3
avatar user
Anonymous
Not applicable

Hi 

 

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

 

Capture.JPG

 

2. Go through split Column options.

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

 

Capture1.JPG

4. Click on Ok 

Capture2.JPG

 

regards,

naveen

meet2aftab
Helper I
Helper I

In Transform option, choose Split Column option and choose Split into Rows optionSplit.jpg

HotChilli
Super User
Super User

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)

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)