Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kalachuchi
Helper III
Helper III

Split two column by row

I have a list below

Kalachuchi_0-1603429837226.png

 

I just want to make KSU and transfer split columns into rows

result will be I will have 3 rows from 1 see image below for outuput

Kalachuchi_1-1603429960516.png

 

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@Kalachuchi ,

Please follow the below steps: (also screen shot)

Step1: Go to Power Query Editor

Step 2: Select KSU column --> Right click on it and select "Split Column" --> By Delimiter --> Choose Comma as a Delimiter 

Step 3: So it will give you 2 columns as per my sample test. 

Step 4: Choose this 2 splited columns and go to Transform Menu and then choose Unpivot Column

Step 5: Then remove the Attribute column from data model

Step 6: Apply and Close

 

112233445566

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

3 REPLIES 3
Tahreem24
Super User
Super User

@Kalachuchi ,

Please follow the below steps: (also screen shot)

Step1: Go to Power Query Editor

Step 2: Select KSU column --> Right click on it and select "Split Column" --> By Delimiter --> Choose Comma as a Delimiter 

Step 3: So it will give you 2 columns as per my sample test. 

Step 4: Choose this 2 splited columns and go to Transform Menu and then choose Unpivot Column

Step 5: Then remove the Attribute column from data model

Step 6: Apply and Close

 

112233445566

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
amitchandak
Super User
Super User

@Kalachuchi , On the right click you have the option to split. Into rows or columns https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

nvprasad
Solution Sage
Solution Sage

Hi,

 

You can get this by unpivot transformation in power query editor.

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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