Monday, December 13, 2021

Use Power Query to Unpivot Report with Multiple Column Row Header Fields

If you've ever gotten a report, it's already been summarized with a specific format with a set of column or row headers (or maybe multiple layers of column or row headers). You'd think that it would take some time with multiple copy and paste steps to get the report view back into a table. With Power Query, you can revert this report back into a proper table so you can do some further analysis in just a few steps.

No comments:

Post a Comment