Pivot table row labels in separate columns

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.

pivot table row labels in separate columns 1So in the adjacent example there are 2 rows of data and they both appear to be in column A.

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.

pivot table row labels in separate columns 2You can do this by changing the report format. So when you click in the Pivot Table and click on the DESIGN tab one of the options is the Report Layout.

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.

pivot table row labels in separate columns 3