Forum Discussion
Solved
How do I collapse a table into a single row in PowerQuery ?
I have the following in a single table: Key TotalPoints TotalPointsA TotalPointsB TotalPointsC TotalPointsD 1 2 2 null ...
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)
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)