none
Pivoting in PowerQuery RRS feed

  • Question

  • Hi All,

    I have following table which needs to be pivoted - 

    Name  -  Sports

    Emp1  -  Cricket 

    Emp1  -  Football

    Emp1  -  Tennis

    Emp2  -  Cricket

    Emp2 -   Tennis

    Emp3 -   Cricket

    as (Pivoted)

    Name -   Cricket   Football  Tennis

    Emp1       1             1            1

    Emp2       1             0            1

    Emp3       1             0            0

     

    Also, note that I have growing list of Names and sports dynamically. 

    How can I achieve this in Power-Query? 

    Thanks 

    Thursday, August 18, 2016 5:00 AM

Answers