Merge Columns from Multiple Tables

[tpmobley]

I have a data model with multiple sources. These sources all have the same field names. I'm needing to create a new table that merges certain columns of interest into one. Here is a simplified example of what I mean:

Table1

color	height	weight
blue	6 ft	125 lbs
green	1 ft	600 lbs

Table2

color	height	weight
yellow	5 ft	200 lbs
purple	12 ft	4 lbs

Table3

color	height	weight
orange	7 ft	3 lbs
black	8 ft	12 lbs

New_Table

color	weight
blue	125 lbs
green	600 lbs
yellow	200 lbs
purple	4 lbs
orange	3 lbs
black	12 lbs

I've tried using Merge Queries in Power Query Editor, but as far as I can tell this only merges two tables. What I need is to be able to extract columns from multiple tables to show in a combined new table. Is this possible?

[Syk · Accepted solution]

You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!