![]() |
I need help matching columns
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 |
All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com