Forum Discussion

Betigolo's avatar
Betigolo
Icon for Helper I rankHelper I
8 years ago
Solved

matrix to table help

Hi,   I need your help.   How to transform the following table:   Name  |  Course1 | Course 2 | Course 3| A         |  YES        |    YES       | NO         | B         |   NO        |    NO...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Betigolo,

     

    You may right click Name column and select Unpivot Other Columns in Query Editor.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Betigolo,

 

You may right click Name column and select Unpivot Other Columns in Query Editor.