Power Query to merge tables into a bigger one

%3CLINGO-SUB%20id%3D%22lingo-sub-341951%22%20slang%3D%22en-US%22%3EPower%20Query%20to%20merge%20tables%20into%20a%20bigger%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341951%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20trying%20to%20create%20a%20master%20table%20that%20is%20fed%20from%20other%20tables%20(they%20represent%20different%20countries).%20All%20the%20tables%20have%20the%20same%20headers%20but%20different%20content.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20objective%20is%20to%20have%20one%20table%20where%20I%20can%20see%20all%20the%20different%20countries'%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20Power%20Query%20I%20have%20only%20been%20able%20to%20add%20different%20columns.%20But%20what%20I%20need%20is%20to%20add%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20do%20that%20with%20Power%20Query%3F%20Otherwise%2C%20what%20tool%20would%20you%20recommend%20to%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-341951%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-342268%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20to%20merge%20tables%20into%20a%20bigger%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-342268%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20Append%20in%20menu%20to%20combine%20them%3C%2FP%3E%3C%2FLINGO-BODY%3E
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