Unpivoting Multiple Rows (but retaining existing Multiple Column values)

[Anonymous]

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

Thank you in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a matrix visual to achieve the same requirement with unpivot function.

Best Regards

[Anonymous]

Have saved a sample table in my Drive: https://docs.google.com/spreadsheets/d/1iLyaa5n1ojlqLTfv7ItsLrr-bWlnPnd0/edit?usp=sharing&ouid=11230...

[chahineatallah]

If possible send your file please