• Update...Couldn't wait as this was an urgent request! (Aren't they all).

    1st step. Created & saved a view with columns mentioned above, plus an extra LineNumber column.

    View is this

    SELECT RowID, Address1 + ' ' + Address 2 + ' ' (etc) as DelAddr, row_number() OVER (partition BY RowID

    ORDER BY RowID) AS LineNumber

    FROM MyTable

    2nd Step.

    Save another view like this:

    SELECT RowID,

    MAX(CASE WHEN LineNumber = 1 THEN DelAddr ELSE '' END) as DelAddress1,

    MAX(CASE WHEN LineNumber = 2 THEN DelAddr ELSE '' END) as DelAddress2,

    MAX(CASE WHEN LineNumber = 3 THEN DelAddr ELSE '' END) as DelAddress3,

    MAX(CASE WHEN LineNumber = 4 THEN DelAddr ELSE '' END) as DelAddress4

    FROM MyView1

    GROUP BY RowID

    SWEEEET!