Correction to the required solution:
Using the sample tables provided in original post, the solution is to get only up to 4 addresses, even if each ROWID has more.
Also, the result will be 5 columns thus:
ROWID, Address1, Address2, Address3, Address4
Each address will be a concatenated address (Address1 + Address2 + Address3 + ADdress4 + Postcode)
Still stumped on how to achieve this, so any help is appreciated.
Cheers, Danster