+ Reply to Thread
Results 1 to 8 of 8

Summarizing data

  1. #1
    Registered User
    Join Date
    11-25-2009
    Location
    Oregon
    MS-Off Ver
    Excel 2003
    Posts
    4

    Summarizing data

    I have a spreadsheet which lists data from customer encounters. For each visit, columns are customer name, item 1, item 2, item 3, and item 4.

    *The spreadsheet has encounters for more than one customer.
    *A customer can have more than one encounter.
    *An encounter can have from one to four items, so while the item 1 column always has a value, items 2-4 can either be blank or have a value.

    I want to summarize, for each customer, the items listed. I only want to report each item once for that customer.

    Example:
    John Q Public, pencil, paper, calculator
    John Q Public, paper
    John Q Public, calculator, eraser
    John Q Public, eraser
    John Q Public, calculator, paper clip, scissors, notepad

    I want to get from that:
    John Q Public, pencil, paper, calculator, eraser, paper clip, scissors, notepad

    The output can be lumped together in a single cell; I don't need them to go into their own columns.

    Is there a way to accomplish this in Excel 2003? Thanks in advance for any assistance.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Summarizing data

    Hi dallymo
    Cant you attach a small workbook with your example
    Just to get the initial data layout right
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    11-25-2009
    Location
    Oregon
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Summarizing data

    Thanks, pike; you bet. See attached; for that data, I would want to see:

    John Q Public: stapler, paper, notepad, paper clip, scissors, eraser, pencil, pen, mousepad.
    Suzy B Good: paper, stapler, eraser, pen, notepad
    Anon Y Mouse: stapler, scissors

    So essentially, listing all of that customer's items and eliminating any duplicates from that customer's list.
    Attached Files Attached Files

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Summarizing data

    Hey dallymo
    Please Login or Register  to view this content.

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Summarizing data

    ops update this bit

    Please Login or Register  to view this content.

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Summarizing data

    a littel rusty
    Please Login or Register  to view this content.

  7. #7
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Summarizing data

    Still There?
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    11-25-2009
    Location
    Oregon
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Summarizing data

    pike, my apologies for such a tardy response--thanks so much, I think you have gotten me on the right track (my project has mutated to incorporate some additional information but the example you provided looks to be just what I need to whip it into shape). I appreciate the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1