Posted in July 2014

Actually “Unpivot” a Pivot Table

When I first started working with Pivot Tables, especially those generated from an external data connection, I remember doing constant google searches that looked something like this: unpivot pivot table excel 2010 remove pivot table excel 2010 Remove pivot table data connection keep pivot data Depivotize a pivot table Why are pivot tables complete jerks … Continue reading

Filter Pivot Table by Cell Format

This can actually be done, if you have the right data in your table. The trick is to create a pivot table in a tabular view with no more than one value column, if at all possible. If you can do that, you should be golden to embark on the magnificent task of being able … Continue reading