Search This Blog

Saturday, February 29, 2020

Convert a Table with a Row Section Header Fields

Do you get reports that have a common row that acts as a header field? It may have other column header fields that make it look like a proper table but there is a row above like the title "Name" and the cell next to it is the actual name of someone. This report is visually okay because it kind of creates sections of table data separated by that row Name-Value pair, but it makes it harder to do any further analysis if you wanted to put is into a Pivot Table or do some aggregation for charts. You could create some formulas, perform copy/paste to fix this, but if this is a large report or something done often, it might be better to use Power Query to transform it into a proper table.

No comments:

Post a Comment