Power Query Help - I am trying to combine two tables - How do I do this?

Hi Everyone,

So I've now moved to Power Queries. Now I am at a loss on how to do this step, each time I tried, I'm not getting the right average.

Table1:

Agent, Score1, Score2

Table2:

Agent, Score1, Score2, Score3, Score4

How do I combine the tables. So when I calculate the average, I am averaging 6 scores together.

My Setup in Power Query:

Table1-Connection Only (Score1 and Score2 column names changed to be different than Table2 only in the PQ connection, not actual column name)

Table2-Connection Only

Can someone help me combine these using Agent as the key to merge the two tables?