Forum Discussion
How do I combine data from 2 excel files into one a unique identifier
Trying to combine data from two sources.
I have two excel files, each file has 2 columns.
File 1 - column one is sku and column two is inventory
File 2 - column one is sku and column two is sold.
I am trying to add column 2 (sold) from file 2 to column 3 on file 1. The data in column of each file is has most of the identical names. but the data is not the same.
Please see examples
File 1
| SKU | On Hand |
| 013964890112 (Fitzgerald Fishing Mega Weigh-In-Bag) | 4.00 |
| 013964890174 (Fitzgerald Fishing Weigh-In-Bag) | 0.00 |
File 2
| SKU | Sold |
| 013964890112 (Fitzgerald Fishing Mega Weigh-In-Bag) | 0 |
| 005103424904 (Strike King Baby Z-Too Pearl Blue Glimmer) | 10.00 |
Trying to create a new file with 3 columns SKU, On hand, Sold.
| SKU | On hand | Sold |
| 013964890112 (Fitzgerald Fishing Mega Weigh-In-Bag) | 4.00 | 0 |
| 013964890174 (Fitzgerald Fishing Weigh-In-Bag) | 0.00 | 7 |
| 005103424904 (Strike King Baby Z-Too Pearl Blue Glimmer) | 0 | 10.00 |
Thank for your assistance - please let me know if i need to clarify .
1 Reply
- https://answers.microsoft.com/en-us/msoffice/forum/all/combine-3-documents/0960df89-09c9-44c7-9555-4e45d7087a8f
consolidate first then run sql?
