Forum Discussion
Solved
Prep survey data results for analysis
Hello, I have received multiple spreadsheets full of tables of aggregated survey data. The tables are matrices that have rows of responses to a question (1 on the low end to 5 on the high end), and c...
Welp, doing one more web search got me the answer. Highlighting the first two columns and then clicking "Unpivot other columns" did the trick.
This is a good explanation of how to handle survey data with PowerBI.
https://www.daxpatterns.com/survey/