To permanently delete blank rows:
1. Select the blank rows by clicking the first row, holding shift, and clicking the last row
2. Right-click and select "Delete x# of rows"
Alternatively, you can filter out blank cells by adding a filter condition for the column where you want to exclude empty values.
If rows still appear empty after running columns, try creating a duplicate column and running it on the filtered empty rows, then merge the results.