How do I repeat labels in Excel for a pivot table field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't figure out how to show a label on a pivot table without hiding
duplicates. For example, instead of the standard pivot summary:

Part Number Work Center Qty
ABC 1 20
2 35
XYZ 5 40
8 20
I want to see it like this with all information shown (nothing compressed):
ABC 1 20
ABC 2 20
XYZ 5 40
XYZ 8 20
 
One option is to copy the entire pivot table, then paste the values and
formatting into a new worksheet. Then highlight column A (part number).
Use ctrl+G to get to the 'Go To' menu. Then select Special>Blanks to
highlight all the blank cells. Now type "=" then press the up arrow. Then
press ctrl+enter. This technique quickly gets the results of a pivot table
into the format you're after.
 
And another option is to add a helper column with a value like R001,
R002 to Rnnn and display it the pivot table as the last field in ROW.
Then you will get one row for every value in the underlying data up
until you hit the max number that the pivot table will deal with (dont
know that number)

hide the column if you dont want to see/print it.

regards..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display all row fields in pivot table 1
Countifs or a pivot 1
Pivot table help 1
How to avoid Duplicate values .. but want the first value to added in group totals 0
How do I perform extended calculations in a Pivot Table in Excel 2 4
Is there any way of combining vlookup with getpivotdata? 1
Pivot Table Calculations 3
Pivot table in Report 3

Back
Top