A simple macro recording can delete all rows in one go that contain blank cells in a particular column. Put on your headphone.
Your browser does not support HTML5 video.