Blank Cells in Pivot Tables

[Greg]

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]

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.