Pinterest Pixel

Repeat All Item Labels In An Excel Pivot Table

Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Repeat All Item Labels In An Excel Pivot Table | MyExcelOnline Repeat All Item Labels In An Excel Pivot Table | MyExcelOnline

Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column.

Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet.

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.

Repeat All Item Labels In An Excel Pivot Table | MyExcelOnline
Download excel workbookRepeat-All-Item-Labels.xlsx

STEP 1: Click in the Pivot Table and choose PivotTable Tools > Options (Excel 2010) or Design (Excel 2013 & 2016) > Report Layouts > Show in Outline/Tabular Form

Repeat All Item Labels In An Excel Pivot Table

STEP 2: Now to fill in the empty cells in the Row Labels you need to select PivotTable Tools > Options (Excel 2010) or Design (Excel 2013 & 2016) > Report Layouts > Repeat All Item Labels

Repeat All Item Labels In An Excel Pivot Table

STEP 3: Your Pivot Table will show all the item labels and you can now copy & paste it into a new area to do further analysis!

Repeat All Item Labels In An Excel Pivot Table

 

728x90

If you like this Excel tip, please share it
Repeat All Item Labels In An Excel Pivot Table | MyExcelOnline Repeat All Item Labels In An Excel Pivot Table | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Move an Excel Pivot Table

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...