A simple solution in my mind is:

Select the relevant rows in column B,

Edit>Go to>Special>Select Blanks

This will select all blank rows. You can then delete  the selected rows by
Edit>Delete>Delete rows.