How do I get a Pivot Table to repeat the values in the columns?

[Sunshine76]

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]

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]

Perfect! Thanks for your help!

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.

 

[Larry P Clark]

Thanks. I was having this same issue myself. I knew there was a way to
solve this by copying & pasting the values, but is there any way to get your
pivot table to fill in the values -- without losing your pivotable-ness?

 

[Dave Peterson]

Nope.

Thanks. I was having this same issue myself. I knew there was a way to
solve this by copying & pasting the values, but is there any way to get your
pivot table to fill in the values -- without losing your pivotable-ness?