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

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.

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

Perfect! Thanks for your help!

"Dave Peterson" wrote:

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