Sol KawageFeb 27
#help do I know any #excel wizards? I have a simple-ish problem and no idea how to solve it, but I suspect it's very easy if you know how:
I have several sheets with code lists on one column and quantities on the other, and I need to merge them into one sheet with the first column of codes, and then the quantities from each of the other sheets in columns.
The caveat is that the code lists in each sheet list might not be 100% the same.
Show threadKilian Evang

@sol Not an Excel wizard, but in database terms, what you want to do sounds like an OUTER JOIN, so that might be a useful search term. This user seems to be asking a very similar question:

https://superuser.com/questions/1023123/how-to-simulate-a-full-outer-join-in-excel

How to simulate a full outer join in Excel?

Let's assume I have some data in Excel (and not in a real database). In one sheet, I have data, where one column functions as the ID, and I have made sure that the values in this column are unique....

Super User
Feb 27 at 11:03amWeb
Show threadSol KawageFeb 27
@texttheater ooh we’re getting somewhere thank you!!!! ☺️