Forum Discussion
Unpivoting Multiple Rows (but retaining existing Multiple Column values)
Hi PowerBI community - I am very new to Power Query, so appreciate any easy pointers please 🙂
How do I 'unpivot' Multiple Rows (but still retaining existing Multiple Column values)?
I wish to transform the original data set such that I will have a unique column for each Measure/ KPI with the corresponding values from "MAT Q2 2022", "MAT Q2 (Sig)","Performance Classification" (see grid below for ideal output)
| Perceived | Perceived | Perceived | Power | Power | Power | Premium | Premium | Premium | |
| Brand Cells | MAT Q2 2022 (MAT) | MAT Q2 2022 vs. MAT Q2 2021 (MAT Sig) | Performance Classification | MAT Q2 2022 (MAT) | MAT Q2 2022 vs. MAT Q2 2021 (MAT Sig) | Performance Classification | Power Index | MAT Q2 2022 vs. MAT Q2 2021 (MAT Sig) | Performance Classification |
| AM | |||||||||
| Ay |
Hi Anonymous ,
You can create a matrix visual to achieve the same requirement with unpivot function.
Best Regards
3 Replies
If possible send your file please
Have saved a sample table in my Drive: https://docs.google.com/spreadsheets/d/1iLyaa5n1ojlqLTfv7ItsLrr-bWlnPnd0/edit?usp=sharing&ouid=112300716569104413902&rtpof=true&sd=true
Hi Anonymous ,
You can create a matrix visual to achieve the same requirement with unpivot function.
Best Regards
