duplicate data to show/print in a column

  • Thread starter Thread starter PAT
  • Start date Start date
P

PAT

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
 
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.
 
You must log in or register to reply here.

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

Pivot Table Duplicate January 2
Duplicates Deletion ? 2
Duplicating Pivot Chart / Changing Pivot Chart data range 4
is there a simple formula that will remove all duplicates in a simple list 1
Pivot Table Data Column Sort Excel 2007 1
How to get pivot table to list duplicate entries in column fields? 2
Duplicate data 2
Counting number of items excluding duplicates. 1

Back
Top