Transpose Data Table

[PowreNoob2]

I have data coming in the following format:

Responder	Q1	Q2	Q3	Q4	Q5
Joe	Disagree	Strongly Agree	Strongly Disagree	Agree	Strongly Disagree
Jim	Agree	Strongly Agree	Disagree	Neutral	Neutral

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

Responder	Question	Answer
Joe	Q1	Disagree
Joe	Q2	Strongly Agree
Joe	Q3	Strongly Disagree
Joe	Q4	Agree
Joe	Q5	Strongly Disagree
Jim	Q1	Agree
Jim	Q2	Strongly Agree
Jim	Q3	Disagree
Jim	Q4	Neutral
Jim	Q5	Neutral

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

[MisterFry · Accepted solution]

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.