There are few things in the world that will remain classics: Casablanca, John Daniels and choosing the Pivot Table “Classic View” when presenting. For those who were not around when the classic view was the standard view, you missed out on a design advantage. Much like how the bench seat in the front row of a car is far more helpful than bucket seats, so too does the Classic View of the Pivot Table serve you today.
What sucks about the way Pivot Tables look now
If you have more than one field in your row value Excel will default to nesting the values in your Pivot Table. This keeps your Pivot Table slimmer, and perhaps more aesthetically pleasing with only a few total rows of data. For me, this is rarely the case, as I often have numerous row values. As such, the bucket seat approach of the modern Pivot Table cramps your style.
Second, if you have two pieces of information that you want to present to the reader side by side, e.g., revenue by State & City, then you might not want to have all your cities nested under each state. Instead you might want the state listed on the same row as your city (so it looks more like an actual table, you know, like what people actually like to read)
Here’s how to do this
Right click anywhere in your pivot table. Select “Classic Pivot Table View”. Be mindful: your pivot table will increase in width, i.e., more columns. This is annoying. We want each row to have it’s own column but not at the expense of a massive increase in pivot table size. No worries, there is an easy fix.
Just change it back
Yup. Change your Pivot Table back to the original/modern view. Excel will not remove your extra columns in the row field. Boss