Paste as values--you will lose the the pivottable-ness of that copy.

Then use one of the techniques from Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html

To fill those empty cells.

Sunshine76 wrote:

I often copy and paste pivot table results on a fresh page to allow for
formulas and v-lookups off of the data. The problem is that the columns I
create in the pivot table only has the data value for that column in the
first row of that section. This is a huge issue if I want to sort once I've
copy/pasted the pivot table as straight data. Any help would be greatly
appreciated.

--

Dave Peterson