Forum Discussion

Anya_T's avatar
Anya_T
Frequent Visitor
4 years ago
Solved

Row to Column

Hi,   I have huge daily incoming data in this format Manager User Id Column 2021-19 anukshag brabhis Actual TIM Time (hrs) 47.99 anukshag brabhis Actual overlap TIM Time (hrs) 47...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anya_T 

    i think you can use pivot in the PQ

    = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Column]), "Column", "2021-19")
daxer-almighty's avatar
daxer-almighty
Solution Sage
4 years ago

Using the Pivot operation in Power Query. (EDIT: Sorry, I first mistakenly wrote Unpivot.)