Try this on a test file since the result depends on what data you have in your sheet (no blanks in data rows):

- press key F5 and click 'Special...' (or Go To Special from menu Home / Find & Select dropdown)
- select 'Blanks'
- OK
- use 'Delete Sheet Rows' (from menu Home / Delete dropdown)