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.