Right-click the row or column label you want to repeat, and click Field Settings. Click the Layout & Print tab, and check the Repeat item labels box. Make sure Show item labels in tabular form is selected. Pivot tables are often used as a means of extracting information from a database, and then the pivot table itself is used as a database. But previously you had to do some work to fill in the blank spaces with the label heading. Now, you can click on the Repeat Item Labels switch and it will do it for you.

Introduction

• Right click, within the pivot table, on the row heading you want to have repeated. Click 'Field Settings' Click 'Layout & Print' Check 'Repeat item labels' You may need/want to also select 'Show item labels in tabular form' if you have not already. This will kick whatever values are lower in the Row hierarchy into a separate column.
• The best layout to use is either the Outline or Tabular layouts. You can then select to Repeat All Item Labels which will fill in any gaps and allow you to take the data of the Pivot Table to a new location for further analysis.
• Hi, Is there any property of Pivot chart in Qlik Sense capable to do the same thing as Excel to show item label in tabular form? I have SKU# and SKU name in the pivot table. I like those two data to be displayed at the same line not in the default hierarchy.

When working with pivot tables, especially OLAP pivot tables, it's often the case that I have needed to flatten the pivot and copy the data to a new sheet to create a new table (a 'flat file'). One important part of this is to fill in the data labels of the rows.
On the Design tab, click Show Report in Tabular Form
Previously to fill in all the labels, on each column I was right clicking, Field Settings | Layout & Print | Repeat Item Labels:
However, this only works for one column at a time.
Repeat All Item Labels
The following is a better way of doing it, below we repeat all the item labels for the whole pivot table in one go with just a couple of clicks:

Click on the pivot table
Click Design

Pivot Table Repeat Data

Click Report Layout | Repeat
Conclusion
It is strange that Microsoft put the two variations of this function in different places. However, it was my mistake not to notice this earlier. Maybe you didn't notice it either? If so I hope this article has helped you.
Excel Version?
Excel 2013 and 2010.

Pivot Table In Google Sheets

Someone on a course this week asked me how you could do the following:

That is, whether you can get Excel to show every row label, even when there are duplicates. The answer, I'm pleased to say, is yes!

Excel For Mac Pivot Table Repeat Item Labels Greyed Out

Repeating row labels

The file for this blog (should you want to try things out yourself) can be downloaded here. The first thing to do is to right-click on the group whose rows you want to repeat, and choose to change its field settings:

Right-click on the group (here it's the travel method we want to repeat, so we right-click on Coach), and choose the Field Settings... option shown.

Next, prevent subtotals appearing for this group (otherwise they will come between the repeated row labels, which looks strange):

Pivot Table Trong Excel

Select None as shown here to avoid subtotalling the travel methods.

Now go to the Layout & Print tab on the same dialog box, and tell Excel to display the pivot tables labels in separate columns, without grouping:

You need to display your row labels in tabular form.

Finally (and still in the same dialog box) tick the box to repeat item labels (at last!):

You should now see your pivot table row labels repeating for each group:

The row labels are now repeated, as required!

And that's it!