Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Using Pivot Table Values | Excel Discussion (Misc queries) | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
How do I get more columns in a pivot table? | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel |