How to combine three columns from different tables into one table

[JihyeHeo]

I have three columns from different tables and I want to combine them into one table.

Please refer to below.

I want to make a table ae below. The important point is that there are many rows wirh duplicate values in the Region and Province columns... Because of this, Merge won't give me the solution. 

I already tried the merge and append fuction but I can't make the table I want. Please help!

[amitchandak]

@JihyeHeo , refer

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

https://www.youtube.com/watch?v=M_jIsnksv7I

[harshnathani]

Hi @JihyeHeo ,

Try the merge option in Power Query.

https://www.youtube.com/watch?v=M_jIsnksv7I

https://www.youtube.com/watch?v=CW-Er8slv9k

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Regards,

Harsh Nathani