Forum Discussion
Solved
How do I pivot to desire format
Hi I have a table that looks like this: ID Q1 Q2 Q1Comments Q2Comments 1 Yes Yes Good Excellent 2 Yes Yes Good Excellent 2 3 No No Not so good Bad 4 Yes N/A ...
jinweitan , In power Query you have to unpivot
refer https://radacad.com/pivot-and-unpivot-with-power-bi
You may have to unpivot twice - https://kohera.be/blog/power-bi/how-to-unpivot-twice/
nandukrishnavs
Community Champion
Community Champion