Excel For Mac Pivot Table Repeat Item Labels

Introduction

• Repeat the Row Labels. A new feature in Excel 2010 lets you repeat those row labels, so they appear on every row in the pivot table. To turn on that feature for all the fields, select the Repeat All Item Labels on the Ribbon’s Design tab. Here’s the pivot table in Outline form, with repeating row labels.
• 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.

So to repeat pivot table row labels, you can right click in the column where you want the row labels repeated and click on Field Settings as shown below. In the Field Settings box you need to click on the Layout & Print tab and choose the ‘Repeat items labels’. Like magic you will now see the row labels repeated on every line.

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
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 For Mac Pivot Table Repeat Item Labels Free

Excel Version?
Excel 2013 and 2010.

How To Repeat Item Labels In Pivot Table