You may delete first cell in second column with shifting cells up. After that you have empty every second row. To remove them select both columns, when Home->Filter&Select->Go to Special. Here select Blanks->Ok. After that Home->Delete->Delete Sheet Rows.
That means your cells below the data are not actually blank, most probably it was some data below which deleted. If you press Ctrl+End you'll be positioned somewhere in row 1792.
Two ways to avoid.
First is to clean such cells. You may check if you have Inquiry (File->Options->Add-ins->COM add-ins (at the bottom)->Go) and activate it. In Inquiry tab on the ribbon click on Clean Excess Cell Formatting.
Alternatively you may add one more step - select not entire column but the range where is your data, let say B1:B20. Manually or by Find & Select->Go To->type in Reference B1:B20->Ok. After that Find & Select->Go To Special->Blanks, etc. as before.