- Export the report to Excel.
- In Excel, highlight any column for which all rows will have data. This is important so you don’t delete data.
- Click ‘Find and Select’ on the Home Tab and select ‘Go To Special."’
- Select Blanks – this highlights all the blank cells in the column.
- Right-click in one of the highlighted cells, and select Delete.
- In the box that appears, select ‘Entire Row’. The blank rows will be deleted.
Connect and collaborate with fellow Blackbaud users.