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!