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: