Home

Power Query to merge tables into a bigger one

Highlighted
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

Hi,

 

Use Append in menu to combine them

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies