cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rojan1918 Frequent Visitor
Frequent Visitor

Transpose all columns except first

I have the following table

 

Udklip.PNG

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Transpose all columns except first

HI @rojan1918 ,

 

On the Query Edito select all columns except the first one and select unpivot columns.

 

Check this documentation for power query.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Super User
Super User

Re: Transpose all columns except first

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





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




3 REPLIES 3
Super User
Super User

Re: Transpose all columns except first

HI @rojan1918 ,

 

On the Query Edito select all columns except the first one and select unpivot columns.

 

Check this documentation for power query.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Super User
Super User

Re: Transpose all columns except first

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





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




rojan1918 Frequent Visitor
Frequent Visitor

Re: Transpose all columns except first

@parry2k @MFelix  Thanks guys. Both worked great.