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