Forum Discussion
Solved
Transpose Data Table
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 ...
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.
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.