Introduction
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.

In Excel 2010 for Windows (and later) the Pivot Table Design ribbon contains a drop-down called 'Report Layout'. Selecting 'Tabular Layout' and 'Repeat all item labels' will show a tabular layout with no blank cells. Unfortunately, this setting is not available in Excel 2011 for Mac. But, the old items might still reserve in the filter drop down, this will be annoying. In this article, I will talk about how to clear the old items in pivot table. How to repeat row labels for group in pivot table? In Excel, when you create a pivot table, the row labels are displayed as a compact layout, all the headings are listed in one column. The good news: there is a way to go back to the original view. The bad news: you have to repeat this step for every pivot table you ever create. To return to a normal layout of the pivot table, follow these steps: 1. Select any cell inside the pivot table. The PivotTable Tools tabs appear in the Ribbon. Go to Design tab of the ribbon. Excel VBA Macro to Repeat Item Labels in a PivotTable –. Use the RepeatAllLabels property of the PivotTable object. Options are xlRepeatLabels and xlDoNotRepeatLabels. Dim ws As Worksheet Set ws = ActiveSheet Dim wb As Workbook Set wb = ActiveWorkbook Dim PTcache As PivotCache Dim PT As PivotTable 'Define the cache for the PivotTable Set.

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

How To Enable Repeat Item Labels In Pivot Table

Click Design
Click Report Layout | Repeat

Excel For Mac Pivot Table Repeat Item Labels Pdf

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.