Shift left if cell = X or Y

Hi guys,

Need to edit a sheet I am scraping from my site.

I need to delete and shift left if a cell equals PICKUP, POSTCODE or is blank.

Is there a simple way to do this. Can I set this function to reapply?

I'm really new to excel, am using open office (Is that a problem?)

Thanks