Forum Discussion
Transpose all columns except first
I have the following table
I need to turn all the columns except the first one into one column. So if there's 10 columns other than the first column I need to make it so for that for the value 1001 in the first column I now need to have 10 rows of the value 1001 in the first column and so forth so that fx
1001 A
1001 A
1001 A
1001 A
1001 A
1001 A
1001 A
1001 A
1001 A
1001 A
HI Anonymous ,
On the Query Edito select all columns except the first one and select unpivot columns.
Check this documentation for power query.
Regards,
MFelix
Anonymous or you can select first column and then right click ad select option, "unpivot other columns"
3 Replies
HI Anonymous ,
On the Query Edito select all columns except the first one and select unpivot columns.
Check this documentation for power query.
Regards,
MFelix
Anonymous or you can select first column and then right click ad select option, "unpivot other columns"