These steps pertain to Microsoft 2010:
  1. Export the report to Excel.
  2. In Excel, highlight any column for which all rows will have data. This is important so you don’t delete data.
  3. Click ‘Find and Select’ on the Home Tab and select ‘Go To Special."’
  4. Select Blanks – this highlights all the blank cells in the column.
  5. Right-click in one of the highlighted cells, and select Delete.
  6. In the box that appears, select ‘Entire Row’. The blank rows will be deleted.
Note: You may lose some Header information depending on which column you select. You can add this information back manually.