How To Merge Queries In Excel: Power Query Combine Made Simple

I spent years manually combining data in Excel until Power Query saved me. Two clicks now replaces hours of copy-pasting and painful errors every single time.

This isn’t about complex formulas or VBA macros. The built-in merge function handles everything from simple appends to complex joins with zero coding. I’ve used it for inventory tracking, financial reports, and even merging customer lists from different systems.

You’ll get clean, combined datasets that update automatically when your source data changes. No more version control nightmares or broken links between spreadsheets. The first merge takes 5 minutes, the next takes even less.

Works with Excel 2016 and newer, including Microsoft 365. Let’s clean up that workflow.

What Youll Need

Instructions

Here’s the process I use to combine data seamlessly without losing a single row.

Open your Excel workbook and go to the Data tab. Click Get Data and import your tables. I always use From Table/Range for existing data, but you can also pull from Text/CSV, Web, or Database sources as needed.

Each table will open in the Power Query Editor. Verify that the data appears correctly—no missing headers, no empty columns. If your data has inconsistencies, clean it up now. Power Query won’t merge data properly if the columns or formats don’t align.

In the Power Query Editor, click Home > Merge Queries. You’ll see options for Inner, Left Outer, Full Outer, Left Anti, Right Anti, and Right Outer joins. For most cases, a Full Outer join keeps all rows from both tables, which is the safest choice if you’re unsure.

Select the key column in each table that contains matching values. This is critical—if the merge key doesn’t match exactly, you’ll end up with missing or duplicated data. Double-check the column names and data types in both tables before proceeding.

After selecting your merge type and key columns, click OK. Power Query will create a new query with the merged data. You’ll see a new column with Table headers—this is the expanded data from the second query.

Click the double-arrow icon in the new column header to expand the data. Choose whether to use the original column name as a prefix or not. I typically leave this unchecked to keep column names clean. Then click OK to apply.

Review the merged data for any errors or unexpected results. Look for columns with null values—this often indicates mismatched keys. If you see issues, go back and verify your merge type or key columns.

Once the data looks correct, click Close & Load to send the merged table back to Excel. The new table will appear in a fresh worksheet. Save your workbook to preserve the query for future use.

Real talk: if your merged table looks off, check for extra spaces or case sensitivity in your key columns. Power Query treats “ID123” and “id123” as different values.

Tips and Common Mistakes

These insights will save you hours of frustration when working with Power Query.

Key Column Precision: In Step 2, the merge key must match exactly—including case and spaces. I once spent an hour troubleshooting a merge failure only to discover a trailing space in one column. Always trim whitespace and verify data types match between tables before proceeding.

Merge Type Strategy: While Full Outer joins are safest for preserving all data, don’t default to them blindly. If you only need records that exist in both tables, an Inner join will give you cleaner results without null values to clean up later. Consider your end goal before selecting.

Null Value Investigation: In Step 4, nulls often appear in merged columns when keys don’t match perfectly. Rather than assuming it’s a data error, check if your key columns contain inconsistent formatting like dates stored as text versus actual date types. Power Query needs exact matches.

Query Organization: After applying your merge, immediately rename the new query to something descriptive like “MergedCustomerOrders.” This small step prevents confusion later when you’re working with multiple queries, and it’s a habit I wish I’d developed earlier in my career.

Frequently Asked Questions

Merging queries in Excel using Power Query is a game-changer for combining data efficiently. With these steps, you can streamline your workflow and save time. Ready to level up? Dive into your datasets and start practicing these techniques today! 🚀