Automatic insert row if cell above contains text or else

Not sure where the blank rows are. I didn't think there were any in the sample I uploaded.

Whatever, just select the whole rows and delete them with the Delete icon on the Robbon, not the delete key.

Regards, TMS