Question on SubTotal function

[Guest]

Hi all,
Just wondering how to get rid of the subtotal function to group the blank
column with the last grouped record... thank you

 

[Dave Peterson]

Replace the blanks with the same key value as the last group.

If you want you could use format|Conditional formatting to make it look like the
cells are still empty (white font on white fill).

If you want to try, visit Debra Dalgleish's site:
http://contextures.com/xlCondFormat03.html#Duplicate