Thanks Alan,

I forgot to mention where the blank cell is I want to delete that entire row not just the cell so the data across the spreadsheet isnt all mixed as it needs to stay in a specific order

See image


\1