Repeat All Item Labels In An Excel Pivot Table

DOWNLOAD OUR
FREE EXCEL GUIDES

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.

DOWNLOAD EXCEL WORKBOOK

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

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

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!

HELPFUL RESOURCE:

If you like this Excel tip, please share it

Email this to someone

Related Posts

Insert Grand Totals to a Pivot Table When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total. How about if you want to remove this Grand Total or show it only for a row or column? Well you have that flexibility and this is how... DOWNLOAD EXCEL...

Sort Field List In a Pivot Table from A to Z Do you ever get in a situation where your Pivot Table Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List? Well you can save time by sorting the Pivot Table Field List in alphabetical order! To do this you need to Right Click...

Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...

Pivot Charts & Slicers In a previous post I showed you how to Insert a Pivot Chart. Now we will take this concept once step further and insert a Slicer. The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart. See how you can start creating some awesome i...

CLICK HERE TO SEARCH OVER 300 EXCEL TUTORIALS

Leave a Comment Cancel reply

thanks

SEARCH EXCEL TUTORIALS