Assuming data is in column A, starting at A2, then add column with formula:

=AND(A2="",A3<>"")

copied down all the way.

Then apply Autofilter (Data|Filter|Autofilter) to the table and filter For TRUE.

Delete those Rows and remove the Autofilter.