+ Reply to Thread
Results 1 to 2 of 2

I have two columns (A) and (G) that have like product codes however

  1. #1

    I have two columns (A) and (G) that have like product codes however

    I have two columns (A) and (G) that have like product codes however
    they are not in any particular order. In columns (H) and ( i ) are bin
    numbers that are associated with the product codes in column (G) I
    would like to put these bin numbers in columns (E) and (F)
    Example of what my worksheet looks like:

    Prod Code Item Name Location Qty Prod Code Bin 1 Bin 2
    BD0036 Oxygen 10 2 BD0100 25
    42
    BD0100 Vent 15 16 BD0036 17
    64

    What I would like for it to look like:

    Product Code Item Name Location ReorderQty Bin 1 Bin 2
    BD0036 Oxygen 10 2 17
    64
    BD0100 Vent 15 16
    25 42

    Note: Column (A) might have 5,000
    product codes with the same product code appearing multiple times
    depending on what locations carry that product and column (G) will have

    20,000 unique product codes only appearing once.


  2. #2
    Dave Peterson
    Guest

    Re: I have two columns (A) and (G) that have like product codes however

    You have an active thread elsewhere.

    [email protected] wrote:
    >
    > I have two columns (A) and (G) that have like product codes however
    > they are not in any particular order. In columns (H) and ( i ) are bin
    > numbers that are associated with the product codes in column (G) I
    > would like to put these bin numbers in columns (E) and (F)
    > Example of what my worksheet looks like:
    >
    > Prod Code Item Name Location Qty Prod Code Bin 1 Bin 2
    > BD0036 Oxygen 10 2 BD0100 25
    > 42
    > BD0100 Vent 15 16 BD0036 17
    > 64
    >
    > What I would like for it to look like:
    >
    > Product Code Item Name Location ReorderQty Bin 1 Bin 2
    > BD0036 Oxygen 10 2 17
    > 64
    > BD0100 Vent 15 16
    > 25 42
    >
    > Note: Column (A) might have 5,000
    > product codes with the same product code appearing multiple times
    > depending on what locations carry that product and column (G) will have
    >
    > 20,000 unique product codes only appearing once.


    --

    Dave Peterson

+ 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