Filter out blank cells in large spreadsheet

Hi

I've got a large spreadsheet with about 27000 lines in it. I need to filter out the blank cells but it seems to have breaks in it so it won't show the option to filter on 'non-blank' so I can just copy the data out.

Is there an easy way to take the blank cells out or will I have to do it manually?

Thanks
George

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