How do I collapse a table into a single row in PowerQuery ?

[EaglesTony]

I have the following in a single table:

Key      TotalPoints   TotalPointsA     TotalPointsB   TotalPointsC   TotalPointsD

1          2                   2                       null                null                 null

1          5                   null                   null                5                     null

1          8                   null                   8                   null                  null

What I want is the final table to look like:

Key      TotalPointsA     TotalPointsB   TotalPointsC   TotalPointsD

1          2                       8                      5                 null

[EaglesTony · Accepted solution]

I was able to do this by using the Pivot feature.

For those that need to do something similiar, here is the video I found: Power Query: How to collapse Multiple Rows to a Single Row (youtube.com)

[AsNa_92]

Hi 

you can sum thte totalpoints columns except the key column as below

[EaglesTony]

I want to do it in PowerQuery as part of the transform, as I am using the data in a stacked bar chart.