Question: How do I change the pivot table so that if I have 2 or more row labels, they can be displayed side by side, in different columns vs. stacked in one column? In other words, please make my Pivot Table look like it did when I used Excel 2003.
My guess is that your pivot table looks something like this:
And you want them to look like this, with the Labels in separate columns:
Just right click on the pivot table and select “PivotTable Options”
Then check the box next to “Classic Pivot Table layout” and click “OK”
Your Pivot Table now looks like this:
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare