It's not possible if you still want to keep it as a pivottable.
But you could copy it and paste special|values (to another location) and fill
the empty cells using techniques from Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html
But this copy won't be a pivottable anymore.
PAT wrote:
I have a pivot table that skips the duplicate data and leave the cell blank
I would like this data to show and print for sorting purposes. How can I do
that
--
Dave Peterson