Search This Blog

Tuesday, May 26, 2020

Unpivot Data with Null or Error Values in Power Query

If your familiar with Pivot Tables, it's basically taking a proper table and summarizing the data for further analysis. However what if you got a pivoted table (aka crosstab or contingency table) already and wanted to do the reverse? In Power Query, there's the option to unpivot (uncrosstab or sort of a transpose) a pivot table view. However it does certain things to the data if it has errors or null values and maybe you don't want Power Query to remove the empty cells or show the error cells. This video will cover both scenarios and the steps to address them.

No comments:

Post a Comment