How to Repeat Row Labels in Pivot Table

This post will guide you how to repeat row labels in same row in your Pivot table in Excel. How do I repeat all row labels in your pivot table in Excel 2013/2016. How to repeat item labels in a PivotTable.

Repeat Row Labels in Pivot Table


Assuming that you have a pivot table in your current worksheet, and you want to repeat all row labels in the same line to make data easier to read. And the below steps will show you how to do it:

Step1: select one cell in your current pivot table.

repeat row lables in pivot table1

Step2: go to Design tab in the Excel Ribbon, and click Report Layout command under Layout group, and select Show in Outline Form from the drop down menu list.

repeat row lables in pivot table2

Step3: you would see that all selected fields are displayed in the current Pivot table.

repeat row lables in pivot table3

Step4: then select Repeat All Item labels under Report Layout drop down list.

repeat row lables in pivot table4

Step5: you would see that all row labels have been repeated for all selected fields.

repeat row lables in pivot table5

 

Repeat Item labels in Pivot Table


If you want only repeat row labels for a specified field in your Pivot table, you can do the following steps:

Step1: select one cell in your current pivot table.

repeat row lables in pivot table1

Step2: go to Design tab in the Excel Ribbon, and click Report Layout command under Layout group, and select Show in Outline Form from the drop down menu list.

repeat row lables in pivot table2

Step3: you would see that all selected fields are displayed in the current Pivot table.

repeat row lables in pivot table3

Step4: right click on “Product” header and select Field Settings, and the Field Settings dialog box will appear.

repeat row lables in pivot table6

Step5: switch to “Layout & Print” tab in the Field Settings dialog box, and then check the Repeat item labels box, and also select Show item labels in tabular form option. Click Ok button.

repeat row lables in pivot table7

Step6: you would see that the row labels have been repeated for that specified field.

repeat row lables in pivot table8

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar