Blank Cells in Pivot Tables
It's been mentioned here about filling in blank cells automatically in a
list of data. Can this be done within a pivot table automatically? I create pivot tables but the row headings are grouped so that some of the items have blank cells next to them. This is frustrating when you want to run a pivot table over the top of the original as it considers these cells blank. As a result you have to copy and paste the row headings into the blank cells and this can be time consuming if you have many lines of data. Can it be done automatically within the pivot table? Can pivot tables be automatically run over the top of another with the blank cells considered automatically to have data within them (i.e. the blank cells created by the grouping of items within row headers?) Thanks in advance for any comments, Greg |
I'm not sure what automatic means here, but if you're creating the same
pivottable (from different data), maybe you could record a macro when you do it manually. You could continue recording when you convert to values and fill those blank cells. And continue recording when you create the second pivottable. Then whenever you need to recreate this, you just rerun that macro. Greg wrote: It's been mentioned here about filling in blank cells automatically in a list of data. Can this be done within a pivot table automatically? I create pivot tables but the row headings are grouped so that some of the items have blank cells next to them. This is frustrating when you want to run a pivot table over the top of the original as it considers these cells blank. As a result you have to copy and paste the row headings into the blank cells and this can be time consuming if you have many lines of data. Can it be done automatically within the pivot table? Can pivot tables be automatically run over the top of another with the blank cells considered automatically to have data within them (i.e. the blank cells created by the grouping of items within row headers?) Thanks in advance for any comments, Greg -- Dave Peterson |
All times are GMT +1. The time now is 12:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com