Sunday, August 1, 2021

Revert a Report with Multiple Header and Total Fields to Proper Table

When you've received a report from someone it would be nice to do your own analysis of the data. However if it's already in some report table format with multiple header or row fields and multiple total or subtotal fields, you'd think that you'd have to do a lot of copy and paste to turn it back into a table so your could do some different pivot or crosstab analysis. With Power Query, you don't need to because the transformation can be done it quite easily and quickly.

No comments:

Post a Comment