How does one:

Subtotal, display only subtotals, copy and paste, and delete all hidden rows.

In doing this one can work with just the subtotal values as a smaller
spreadsheet.

thanks, Winslow