Forum Discussion

koorosh's avatar
koorosh
Post Partisan
5 years ago
Solved

Transform

Hello experts, How to get the down table from the above one in the image, please?      
Need Help
  • Portrek's avatar
    Portrek
    5 years ago

    Hi.

     

    In Power query select your first column and choose the option Unpivot Other Columns

     

     

    Best regards.

MintuBaruah's avatar
MintuBaruah
Helper III
5 years ago

Hi koorosh 

 

I tried the following solution.

 

First, you need to select the columns and then unpivot them(refer to screenshot 1).

Screenshot 1:

 

Which will give you the following output(refer to screenshot 2):

Screenshot 2:

 

 

If you find the solution useful please mark my post as a solution!
In doing so, you are also helping me. Thank you!

Mintu Baruah