Merge two queries with the exact same column & without duplicate row

[PierreL69]

Hello community,
I am writing to you because I cannot do what I want, which seems simple to me
I want to join two queries or two tables that have exactly the same structure (same column), joined based on one column so that there is no duplication

So I want to use the merge function but the join Kind I need is not there, below is what is available

And what I want is  :

But I cannot find this joint type.

Edit: Sorry I did my message too quickly what un want to join is the red circle + the blue part

Someone have an idea ?

Thanks

[ppm1 · Accepted solution]

Please see this video. It shows how to do two anti joins and append the results.

Performing a full Anti Join in Power Query - Compare Two Tables - YouTube

Pat

[PierreL69]

After looking at the video I found my solution which needed to be done in two steps, thanks a lot !!!

[PierreL69]

Hi I am sorry I did a mistake in my drawing what I want to get is the whole red circle + the blue part