Remove subtotal problem

I received a large Excel worksheet that includes subtotal data. I need to copy this data to another worksheet showing all the data lined up without the subtotal and blank rows. I tried the “Subtotal – Remove All” feature but that didn’t work. What I can do is manually delete the subtotals one by one by but that is time consuming. Any advise, tips? Thanks.