Forum Discussion
Report: grouped by rows & columns (is this possible?)
Greetings everyone - report builders especially, I have a batch of survey responses (Answer Text) and I'd like to view them grouped by users (rows) & questions (column headings). Is this possible to...
And I have used Power Query before to help solve a different Excel problem. It's a great plug-in!
stevep17 Something like in the attached file perhaps. First a bit of cleaning up in PQ, then some Power Pivot.