How to remove or delete empty or blank rows in Google Sheets?

1. Select the Rows.

2. Go to Data menu and select “Create a filter”.

 

3. Select Clear and then select Blanks. Click OK Button.

4. Selected the Blank rows. Right Click and select “Delete selected rows”

5. Select Remove Filter from Data Menu.

Output: