Forum Discussion

stu_adz's avatar
stu_adz
Frequent Visitor
2 years ago
Solved

Summarize and transpose into new table using column headers as row labels

Hi there,   I have looked at similiar posts but the solutions presented did not seem to work for me. I am very new to PowerBI and I have the following sampe data set:   I am trying to achi...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, stu_adz 

     

    You can try the following methods. Select the first two columns-Unpivot Other columns:

    Result:

    Using the matrix view:

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, stu_adz 

 

You can try the following methods. Select the first two columns-Unpivot Other columns:

Result:

Using the matrix view:

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.