G
genesisoxygen
I have two columns (A) and (G) that have like product codes however
they are not in any perticular 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:
Product Code Item Name Location ReorderQty
Product 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
I have 20,000 rows and would appriciate any kind of help i can get
they are not in any perticular 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:
Product Code Item Name Location ReorderQty
Product 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
I have 20,000 rows and would appriciate any kind of help i can get