Transform Column to Row

Anonymous · ‎05-15-2023

I have current table as below; how can I transform to get the result table;

Thank you!
Qayyum Halid

miTutorials · ‎05-15-2023

Go to Power Query Editor

1. Select Q1 & Q2 column, Right click and choose Unpivot column

2. Repeat the same step above by selecting the Whats your name and Age Column

You will be left with the way you want your table to look like but with duplicate rows.

Go to HOME tab under remove rows select remove duplicate rows. Thats it !

This Tutorial will provide you more details if required.

Regards

Ismail

Anonymous · ‎05-15-2023

It become like this;

Then, if i remove Attribute duplicate; it become as below;

If i remove duplicate in Attribute.1, it become as below

Helpful resources