Arranging address columns (with blanks) to start from the left

[mattc_uk]

Hi

I have a huge spreadsheet of addresses with the following headers

Name | Address1 | Address2 | Address3 | Address4 | PostCode

Joe | Somewhere | Here | London | | WA12 1AA
John | 1 John's Road| Manchester | | | M11 1AA
etc....

This will be saved as a CSV and I want to somehow get all spaces removed between the last address and the postcode and the postcode simply added to the end of each record. (ie everything moved to the left and overwriting any blank columns. Postcode field would simply be renamed to address5 as it may or may not contain a postcode anymore)

In the above example, 'WA12 1AA' would be moved to Address4 and 'M11 1AA' would be moved to Address3

Does anyone know how I can do this on mass?

Regards