Transpose all columns except first

[Anonymous]

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

[MFelix · Accepted solution]

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]

@parry2k @MFelix  Thanks guys. Both worked great.

[MFelix · Accepted solution]

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

[parry2k · Accepted solution]

@Anonymous or you can select first column and then right click ad select option, "unpivot other columns"