Forum Discussion

Jaweed's avatar
Jaweed
Helper III
5 years ago
Solved

Assistance ( Reposted - wrong location)

Hi everybody   How to transform a table in PowerBi 2 hours ago Hi everybody Can Anybody assist me? I have a table in Power Bi that I uploded. Typical records are as below. Company       C...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Jaweed 

    You can try the following steps:

    Sample:

    Step1:Transpose column in Query Editor

    Step2:Use First Row as Headers

    Step3:Merge columns

    Step4：User Headers as First Row and Transpose columns

    Step5:Duplicate columns and split columns

    Result:

    Finally, to change the name of the first column to what you want.

     

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

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

Hi, Jaweed 

You can try the following steps:

Sample:

Step1:Transpose column in Query Editor

Step2:Use First Row as Headers

Step3:Merge columns

Step4：User Headers as First Row and Transpose columns

Step5:Duplicate columns and split columns

Result:

Finally, to change the name of the first column to what you want.

 

 

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

 

Best Regards,
Community Support Team _ Zeon Zheng