I have a large spreadsheet that I've inserted subtotals into. It calcs subtotals correctly. I only want to print the subtotal line, but with the detail data that goes with it, what's listed directly above the subtotal line.
How can I print the detail fields on the subtotal line. For example my spreadsheet looks like this with the subtotal in inserted...

cakes 25 chocolate 10/14/07
cakes 1 chocolate 10/14/07
26
cakes 10 chocolate 10/28/07
cakes 5 chocolate 10/28/07
15

The only data I want to print out is
cakes 26 chocolate 10/14/07
cakes 15 chocolate 10/28/07

Any ideas?
Thanks