I have two excel files that I'd like to merge as easily as possible rather than going row by row. The data on one is sales YTD and the data on the other is sales on a Rolling 12 month. I have some items that have been sold to an account on a R12, that haven't been sold YTD so my rows don't line up perfectly. I am hoping there's a way for Excel to figure this out, and match the first column up to fill in the data. I'll try to show below....
How I'd like the final file to look
File 1 | File 2 | |||||
Account 1 | Item 1 | 5 | Account 1 | Item 1 | 8 | |
Account 1 | Item 2 | 3 | Account 1 | Item 3 | 5 | |
Account 1 | Item 3 | 4 | Account 2 | Item 1 | 1 | |
Account 2 | Item 1 | 8 |
How I'd like the final file to look
FINAL FILE | |||
Account 1 | Item 1 | 5 | 8 |
Account 1 | Item 2 | 3 | |
Account 1 | Item 3 | 4 | 5 |
Account 2 | Item 1 | 8 | 1 |