Forum Discussion

Betigolo's avatar
Betigolo
Helper 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
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Betigolo,

     

    In your scenario, you should be able to use the Unpivot Column option in Query Editor to unpivot the Course columns to get your expected result. For more details about how to Pivot and Unpivot with Power BI, you can refer to this article. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Betigolo,

 

In your scenario, you should be able to use the Unpivot Column option in Query Editor to unpivot the Course columns to get your expected result. For more details about how to Pivot and Unpivot with Power BI, you can refer to this article. :smileyhappy:

 

Regards

Betigolo's avatar
Betigolo
Helper I
8 years ago

Many thanks..... so easy and clear. Awesome