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

"sonya" wrote:

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