Home

Power Query to merge tables into a bigger one

Pablo12
Occasional Visitor

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
Highlighted

Hi,

 

Use Append in menu to combine them

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies