If I got 1000 records and in-between each row record there is a blank row. Is there any shortcut to remove the blank rows in-between them so i'm able to use the auto filter function? Or able to transfer all the records over to another excel sheet with no blank row. Any help will be much appreciated.

I dont want to spend my time removing the blank row one by one. Too time consuming. What if i got 10000 records?