Forum Discussion

wynseun's avatar
wynseun
Regular Visitor
3 years ago
Solved

Pivot/unpivot without aggregation gives error

I'm trying to figure out how to pivot my data on the Attribute column from long to wide format.   Team Attribute Value A Score 123 A Year 1999 B Score 156 B Year 1999 A ...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi,

    to obtain this i have added a new column

    = List.Combine( {List.RemoveFirstN( Source[Value],1),{"null"}}) 

    transposed it and then added to the original table (which has been stransposed)

    Then transpose one more time and you get your result

    The advantage is that is all dynamic

    If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
3 years ago

Hi,

to obtain this i have added a new column

= List.Combine( {List.RemoveFirstN( Source[Value],1),{"null"}}) 

transposed it and then added to the original table (which has been stransposed)

Then transpose one more time and you get your result

The advantage is that is all dynamic

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!