Hello, I want to merge two different spreadsheets that share common row identifiers (alfa, beta, gama) and can be sorted by this identifier. Some of identifiers in one sheet are not present in another one. I want to end up with one sheet having only row identifiers that exist in both sheets and their corresponding values from both sheets. For an illustration:
spreadsheet 1
alfa 5467
gama 2345
beta 678
spreadsheet 2
beta 3244
gama 798
result:
(no alfa here)
beta 678 3244
gama 2345 798
Thanks.
Bookmarks