Flattening Data
 

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.

Flattening Data
 

This begs to ask if you're managing residences or occupants. Your
explanation suggests residences and so your data needs to be sortable
by address.

The result sample you posted does make any sense to me. If managing
occupants then would simply filtering by residence address serve your
needs? Or would a Pivot Table be a better way to go?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Flattening Data
 

GS made a typo:
This begs to ask if you're managing residences or occupants. Your explanation
suggests residences and so your data needs to be sortable by address.

The result sample you posted does not make any sense to me. If
managing occupants

then would simply filtering by residence address serve your needs? Or would a
Pivot Table be a better way to go?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion