number of ways you can do this...i had the same question earlier.
1. highlight the subtotals results that you want to copy. hit F5
special and "visible cells only" then ctrl C, which sould highligh
with white lines the subtotals you want to copy. then ctrl V t
wherever you want. it'll get rid of all the data in the hidden row
and leave only the subtotal results.
2. copy and paste from Excel into Word and back again. That should d
the trick.
3. Copy and paste your subtotals normally. When it's expanded, sor
with using one of the empty columns. At the bottom should be all th
cells with "total" from the subtotal function. Any cell above wer
hidden previously....which you can now delete.
I hate deleting data when it's not really necessary. if you do,
suggest you backup your data before doing any deleting