The ability to have repeated item labels is in the Excel 2010 version for PC, but I cannot find the same function in Excel 2011 Mac. If the function is not in Excel 2011, is there a workaround to 'copy' the item label to blank cells below the first label? I am struggling to find the 'repeat item labels' for an Excel Pivot table on the Mac version of Excel. Can anyone point me in the right direction? I couldn't find it! In Windows it is under Field SettingLayout and PrintRepeat Item Labels. Where is the equivalent function in a Mac? Many thanks, Remon. I created a pivot table where Rows are YEAR and MONTH and data is SUM - PRICE. A pivot table was created like this. YEAR MONTH SUMPRICE 2013 1 15.65 2 5.7 3 234.5 4 35.0 2014 1 XX But I want to repeat the year per each row automatically like this. 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.
One of the new features in Excel 2010 relating to Pivot Tables is the ability to repeat the item labels. Why is this useful?
![Pivot table pandas Pivot table pandas](/uploads/1/1/9/8/119855444/492189253.png)
What Is A Pivot Table
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.
Pivot Table Repeat Data
Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page