Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does VBA support flattening/serializing to "binary" string? | Excel Programming | |||
combining or "flattening" rows | Excel Worksheet Functions | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
flattening aggregated fields in pivot table | Excel Discussion (Misc queries) |