Hide blank cells

I am exporting information from excel into another program.  I don't want all the info.  I used to be able to select the filter in at the top of a column and choose to hide blank cells.  Then the info on the rows next to the blank cells would hide.  When I copied the info out, I did not have all the extra info.  This no longer works for me.  How do I do this?

Person's name      time spent      $

                                     2             $10

                                     1             $5

I want:

Person's name           time spent       $