| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a Pivot Table to repeat the values in the columns?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a Pivot Table to repeat the values in the columns
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a Pivot Table to repeat the values in the columns
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" 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a Pivot Table to repeat the values in the columns
Nope.
Larry P Clark wrote: 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" 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
