Forum Discussion

amalrio's avatar
amalrio
Icon for Helper V rankHelper V
5 years ago
Solved

how to unpivot table with multiple columns

Hi Gurus,    I have a requirement to unpivot a table with multiple columns, not sure how would I go about it and would ended up giving me incorrect results. below is the image of my tabel, any help...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • amalrio's avatar
    amalrio
    Icon for Helper V rankHelper V
    5 years ago

    Hi amitchandak , 

     

    thanks a lot for the reply, 

     

    I just found out, so say if I want to group by some of the Project stage say I only want to group the totals for year by when it is implementation? and not whne colse out and define, how do I do that

     

    Thanks again mate

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amalrio 

      If you want to sum the values by year and project, you could try group by function in power query editor.

      My test table:

      I unpivot 2020 and 2021 column , then use gourp by function. Result is as below.

      If this reply still couldn't help you solve your problem, please provide me with your screenshot of the result you want. This may make it easier for me to understand your requirement.

       

      Best Regards,

      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.