How to get pivot table row labels in separate columns
A common query regarding Pivot Tables in the more recent versions of Excel is how to get pivot table row labels in separate columns.
This is fine for viewing and useful for printing, but if you want to use the data from the pivot table in a sheet somewhere else, when you copy and paste it, it will come out looking like this which makes it hard to sort or filter on the data.
The issue here is simply that the more recent versions of Excel use this as the default report format. Our preference is rather that the pivot tables are shown in tabular form.
Click on this and change it to Tabular form.
Your pivot table report will now look like the bottom picture and will be easier to use in other areas of the spreadsheet and in our opinion is also easier to read.