I have a spreadsheet with two sheets. SheetA has Customer number and location, and SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and location? Every column of SheetA is unique, but SheetB may have the Customer number show up more than once.
I've a few thousand of these records to do, so doing it by hand isn't really an option. Also is there a way do this via Base (database)? I have this data in Base, but I exported it to spreadsheet to see if it would be of help.
