Power Query to merge tables into a bigger one

Copper Contributor

Hello, I am trying to create a master table that is fed from other tables (they represent different countries). All the tables have the same headers but different content. 

 

The objective is to have one table where I can see all the different countries' data. 

 

With Power Query I have only been able to add different columns. But what I need is to add rows.

 

Is there any way to do that with Power Query? Otherwise, what tool would you recommend to use?

 

Thank you very much!!

1 Reply

Hi,

 

Use Append in menu to combine them