HELP! Need to Sort Customer Address List into Postcode Order

If that's the full file it's probably quicker to just copy the postcodes to a separate cell, there's only 587 rows and some of those are blank.

Here's one way of doing it, though it's a bit long-winded and so I'm not sure it's any quicker than doing a manual copy-and-paste as Special-K suggested.

1. Get rid of all the merged cells by selecting the entire sheet (click the grey area to the left of A and above 1 with a darker grey triangle in it), then click to de-select the 'Merge and Centre' button in the 'Alignment' section of the 'Home' tab.

2. Enter two new columns after column G - new columns H and I.

3. In H7, enter this:

Formula:

Please Login or Register  to view this content.

4. In I7, enter this:

Formula:

Please Login or Register  to view this content.

(3) and (4) together will change the vertically-arranged addresses into horizontally-arranged ones. (If all you have is a postcode, it'll be duplicated in columns G and I.)

5. Select H7:I9 (both columns, three rows). Using the 'drag handle' at the bottom-right of the selection, drag down to the bottom of your data (row 588).

6. Select H7:I588 and copy, then right-click in the selection and click 'Paste Values' (the symbol which looks like a clipboard with '123' on it, under 'Paste Options'). Press 'Esc' to de-select the area.
This replaces the formulae from (3) and (4) above with their results.

7. Select B7:B588 (the column with the heading 'A/C'). Do not select the entire column. Press F5, then click 'Special', then select 'Blanks' and click 'OK'.
This will select all the rows which are blank in this column. On the 'Home' tab, in the 'Cells' section, click 'Delete' and then 'Delete Sheet Rows'.

You now have a table with everything for each company on one row, with postcodes in column I. Sort it as you want.

(It's undoubtedly possible to write a macro to do all of this, but I'm not good enough in VBA to do it. If all your files are identical, you might be able to record the above the first time and copy the recorded macro to run on the other files, but I suspect the row numbers will be different at the very least.)

Good luck.