Combining the contents of two tables or sets of data.

Hi everyone, this is my first post here and first time here. I was wondering if you could help me with what is probably a pretty simple question.

I am trying to combine two tables (or two sets of data in two columns together)

Example:
Example.PNG

As you can see both tables have letters that correspond to one another and some that do not. The end goal of this combination would be to put both datasets into one table and combining the integers that correspond to the respective numbers and then adding new row for those that do not correspond.

Just as an example the end result of this would ideally be

Example 2.PNG

As you can see A B C D E and H I J have combined into one line, F and G, already existing in the first table remain the same. K and L, unique rows from the second table have been added to the first one. These do not have to be tables if it is easier, they could just be rows and columns and then made into tables after.

I figure I am missing something quite obvious here, I guess my brain has shut down for the weekend - I did these manually in the example but this needs to be done for several hundreds rows over a load of documents. My job description does really involve a tremendous amount excel but over the last year I have found myself using formulas a lot! This though, I am unfamiliar with.

Thank you for your help.

well, to sum the data where more than 1 num appears associated with any given letter, the SUMIF() function will do that for you. so check that out. regarding the creation of new rows in a table for the other data, more than likely there is more than one resource in excel to do it, however code would probably be easiest. I don't use interface functions in excel at all, hardly ever, so if there is an answer in that regard, i would not be the person to ask.

by the way, welcome to this community. I have a friend in Dallas. a real estate investor. very intelligent man. he's not a technology person, but still, based on what he does, one can learn a great deal from him. I am a big fan of Texas.