When I use the subtotal function on the Data tab, the "grand total" appears
several hundred lines between the last sub-total & the grand total.

Is there a method that will eliminate the additional blank lines between the
last sub-total & the grand total