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 Item 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 Row 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

 

Related Posts

Excel/Google Sheets: Absolute Reference

In Microsoft Excel spreadsheet or Google Sheets, the cell reference is the cell or cell area address or name in the worksheet, the cell reference contains two types of references, namely, relative references and absolute references. Absolute Reference An absolute ...

Conditional formatting based on another column in Google Sheets or Excel

In Microsoft Excel Spreadsheet or google sheets, conditional formatting is used to highlight any cell based on a predefined condition and the value of those cells. In the previous article, we described how to format a specific column or cell ...

Conditional Formatting based on Another Cell in Google Sheets/Excel

In Microsoft Excel Spreadsheet or google sheets, when you want to format a specified cell or cell range based on the value of a different cell, for example, formatting the first row based on the value of a cell in ...

Compare Two Strings in Excel/Google Sheets

This article will talk about how to compare two given strings in a Microsoft Excel spreadsheet or Google Sheets. How to compare two strings in Excel by using VBA macros to see if they are the same, if they are ...

Compare effect of (non-annual) compounding periods on growth

This article will talk about how to calculate the trend or effect of future value changes for different compounding periods in a Microsoft Excel spreadsheet or Google Sheets via a formula. What is the period of compound interest? The compounding ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar