1. Open the exported report in Excel
2. Select Edit, Go To, Special, and Blanks from the menu bar
3. The blank lines are highlighted. Press Delete.