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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jinweitan
Frequent Visitor

How do I pivot to desire format

Hi

 

I have a table that looks like this:

 

IDQ1Q2Q1CommentsQ2Comments
1YesYesGoodExcellent
2YesYesGoodExcellent 2
3NoNoNot so goodBad
4YesN/AOkayNot applied.

 

and would like to make it like this

IDQuestionsAnswerCommentsAnswerComments
1Q1YesQ1CommentsGood
1Q2YesQ2CommentsExcellent
2Q1YesQ1CommentsGood
2Q2YesQ2CommentsExcellent 2

.

.

.

 

Is there anyway possible to do that?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
3 REPLIES 3
nandukrishnavs
Super User
Super User

@jinweitan 

 

Refer to the attached pbix file.


Regards,
Nandu Krishna

amitchandak
Super User
Super User

AiolosZhao
Memorable Member
Memorable Member

Hi @jinweitan ,

 

1. Click the "Transform data" button to get into the Power Query Editor page.

2. Choose the table on the left and right-click the ID column.

3. Choose Unpivot other columns.

 

How do I pivot to desire format.PNG

 

You may need to duplicate your table and unpivot them separately.

 

Then using the merge function to get what you desired table.

 

Please try.

 

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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