Forum Discussion

PowreNoob2's avatar
PowreNoob2
Frequent Visitor
4 years ago
Solved

Transpose Data Table

I have data coming in the following format:

Responder  Q1Q2Q3Q4Q5
JoeDisagreeStrongly AgreeStrongly DisagreeAgreeStrongly Disagree
JimAgreeStrongly AgreeDisagreeNeutralNeutral

 

I'm needing to convert the data into the following structure:

Responder  QuestionAnswer
JoeQ1Disagree
JoeQ2Strongly Agree
JoeQ3Strongly Disagree
JoeQ4Agree
JoeQ5Strongly Disagree
JimQ1Agree
JimQ2Strongly Agree
JimQ3Disagree
JimQ4Neutral
JimQ5Neutral

 

I've tried Transpose and Pivot but those are not getting the data like I need it. Any suggestions on how to acheive this.

Need Help
Tips and Tricks
  • MisterFry's avatar
    MisterFry
    4 years ago

    In Power Query (M) you should be able to select the responder column, and then select 'unpivot other columns' from the right-click context menu to transform the data to the required format. 

1 Reply

  • MisterFry's avatar
    MisterFry
    Resolver III
    4 years ago

    In Power Query (M) you should be able to select the responder column, and then select 'unpivot other columns' from the right-click context menu to transform the data to the required format.