Merge 2 table and bring each data from both table

[yvanka46]

Hi All,

I wonder if someone can help me with merge queries.

I am using Power Query in Excel and I would like to know the best way to do this task please.

I have 2 tables,

and I want the output like this,

I would really appreciate any help, thanks a lot!

[yvanka46]

Hello @Idrissshatila , thanks..

I've tried all that joins but it still doesn't work like result table

[Idrissshatila]

Hello @yvanka46 ,

refer to this article https://learn.microsoft.com/en-us/power-query/merge-queries-overview