Forum Discussion

NehaSha's avatar
NehaSha
Icon for Helper II rankHelper II
7 years ago
Solved

Matrix show on rows

Hi All,   Need help for the below mentioned scenario. I treied one solution but couldnt resolve formatting for each columns as expected and sorting acc. to Expected result, along with Percentage co...
Need Help
  • KBO's avatar
    KBO
    7 years ago

    As mentioned above:

    1) Go to "Edit Queries"

    2) Select all Colums

    3) Transform: Unpivot Columns

     

     

    Best Kathrin

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi NehaSha ,

 

You could unpivot table in Query Editor mode to transform columns into rows.

 

Regards,

Yuliana Gu