A few methods, with pros and cons of each

If your Excel document contains thousands of rows, manually removing blank lines can be stressful and nearly impossible. You can use Excel macros to clean up your data, but it can be tricky if you're not familiar with macros.

In this tutorial, you'll learn how to delete blank rows in any version of Excel, from Excel 2003 to Excel 2016 and later.

Sorting is a simple and effective way to remove blank lines without macros.