Results 1 to 2 of 2

Thread: Flattening Data

  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unanswered: 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

    Im stuck on how to do this! Any help would be really welcome.

  2. #2
    Join Date
    May 2012
    Posts
    10
    Quote Originally Posted by Davywatuk View Post
    I need to create a list...
    Sort by address then use Data->SubTotal. This will show you how many residents live at each address.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •