Power Query to Join 2 Tables with same identical columns and update matching records on the left table from the right table

[amanphilip]

Hello Good Day!

I am new to developing Power Query and I am currently Joining 2 tables. From the examples I have seen when using left join the theory is like this

But what I am trying to do is this:

Is this achievable? Thank you!

 

[amanphilip]

Hello Good Day!

I am new to developing Power Query and I am currently Joining 2 tables. From the examples I have seen when using left join the theory is like this

View attachment 95448


But what I am trying to do is this:

View attachment 95450


Is this achievable? Thank you!

Edit:

Here's what I am trying to achieve.