Good Morning All,

I have been assigned a task @ work and I need to sort a rather large list of customers into post code order. Ideally, so the relevant person can skim down the list and pick out the closest customer to him at that moment.

I have had to extract data from our system at work to provide the customer list in an excel format, however, the data is a bit of a mess with extra columns and rows everywhere. (See below).

CUSTOMER BY POSTCODE.xlsx

Can anyone provide any suggestions on how I can get my head around this? I have x4 to do for each area in the UK we cover.

Yours, hopefully,
Sam