+ Reply to Thread
Results 1 to 5 of 5

Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns

  1. #1
    Registered User
    Join Date
    06-12-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns

    Hello,

    I have a large data file I need to process. I need to lookup values in column A (which repeat), and find their corresponding unique values in column B, and for each unique item found in B, copy it to C (item 1), D (item 2), E (item 3), etc.

    It's a little difficult to explain so I am attaching a basic sample of a before and after file.
    I appreciate any help; I'm stumped.

    Thank you
    Attached Files Attached Files

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

    Re: Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Column

    Hi nzxt1234,
    Welcome to the forum.
    Its hard to follow what is what with the supplied examples.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    06-12-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Column

    Thank you.

    I will try and post a better example with some more explanation.

    I have a list of products and stores they were purchased at:

    Coca Cola | K-Mart
    Coca Cola | Walmart
    Pepsi | Costco
    Pepsi | Costco
    (see Initial Data.xls)

    I need a function, a lookup I believe, that will find all unique stores and put them in a new column for a given product:

    Coca Cola | K-Mart | K-mart | Walmart
    Coca Cola | Walmart | K-mart | Walmart
    Pepsi | Costco | Costco
    Pepsi | Costco | Costco
    (see data after column lookup.xls)

    I will then apply an advanced data filter for unique records, and delete/hide column B, so that it displays the data like so:

    Coca Cola | K-mart | Walmart
    Pepsi | Costco
    (see data after unique record filter.xls)

    I hope this helps, and I appreciate yours
    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,327

    Re: Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Column

    maybe something like
    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,327

    Re: Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Column

    or even
    Please Login or Register  to view this content.

+ 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