I have data in the form of a list of residents, each record or row is a description of the resident with a unique ID for the person and one for the address. Each address may have one or more resident e.g.

Res1 – Joe Jones – Add1 - 10 Glebe Street
Res2 – Anne Bloggs – Add2 – 12 Smith Street
Res3 – Bill Bloggs – Add2 – 12 Smith Street
Res4 – Frank Smith – Add3 – 5 Poplar Lane
Res5 – Jane Smith – Add 3 – 5 Poplar Lane
Res6 – Bob Smith – Add3 – 5 Poplar Lane
Res7 – Dave Frank – Add4 – 12 Bridge Street
Res8 – Paula Frank – Add4 – 12 Bridge Street

I need to create a list where each address has only one record / row and each resident is described in the record e.g.

Res1 – Joe Jones – Add1 - 10 Glebe Street
Res2 – Anne Bloggs – Add2 – 12 Smith Street - Res3 – Bill Bloggs
Res4 – Frank Smith – Add3 – 5 Poplar Lane - Res5 – Jane Smith - Res6 – Bob Smith
Res7 – Dave Frank – Add4 – 12 Bridge Street - Res8 – Paula Frank

I’m stuck on how to do this! Any help would be really welcome.