Split Excel pivot table rows into separate columns

For the last few versions of Excel, the standard pivot table format is to have all of the Row fields displayed in one column.

 

 

But if you want to split your row fields into separate columns, you can switch to the “classic” pivot table view from earlier versions of Excel.

 

Right-click on the pivot table, go to PivotTable Options and from the Display tab tick:
Classic PivotTable layout (enables dragging of fields in the grid)

 

 

And the pivot table will revert to the older, classic layout with all row fields displayed in a separate column.

 

Leave a Reply

Your e-mail address will not be published. Required fields are marked *