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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi koorosh ，

 

As they said, you could use unpivot in power query; and another method is to create a new table through the following form：

Newtable =
VAR _new1 =
    SUMMARIZE ( 'Table', [Company Name], [Service1], "Type", "Service1" )
VAR _new2 =
    SUMMARIZE ( 'Table', [Company Name], [Service2], "Type", "Service2" )
VAR _new3 =
    SUMMARIZE ( 'Table', [Company Name], [Service3], "Type", "Service3" )
RETURN
    UNION ( _new1, _new2, _new3 )

The final output is shown below:

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.