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 va...
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"
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"