delete emty rows:

select A1
press and hold CTRL+SHIFT
pull down-arrow until all rows with values is selected
if u reach A65536 then pull up-arrow onse

now press F5 and click on Special
check out Emty cells
click ok

right click and select Delete