Return non blank cells in a row throughout a table?

[zuki01]

H Hi

I have made a macro (using a lot of help from this forum) to produce a table made up of rows with postcodes in and then some blank cells before the next postcode my drivers go to.

My problem is that the postcodes come out in different columns. So in A1 is a postcode and in D1 is the next postcode and then the next driver on row B has his postcodes in B2 and C2.

I want to put a formula in say column F that can copy down and find the first postcode and then a formula in column G and copy down to show the second.

I’ve tried to do it with Index and Find functions but to no avail.

Any help would be much appreciated.

Thanks.