different tables being combined

Google Sheets – Combining Tables With Different Data Using VLOOKUP

When using Google Sheets, often times you can find yourself wanting to pull data from one table into another. However, these two tables don’t always have the same types of data in the same order. As long as there is at least one value in common, you can use a few tricks to bring data from different tables together into one combined table.

See this YouTube video for a walkthrough of the steps.

We will go over how to do this using several relatively basic steps and ending with the super-useful VLOOKUP formula. VLOOKUP typically looks to the right (we’ll get there), but we can also trick the function and have it look to the left.

In September 2022, Google Released the XLOOKUP function. It is an easier to use and more flexible alternative to VLOOKUP.

 Live examples in Sheets

Go to this spreadsheet for examples combining data.

combine tables with FILTER

Google Sheets – Combine Data without Query | Different Worksheets

This post is written to accompany the YouTube video showing how to combine multiple tables of data in your Google Sheet without using the QUERY function.

Oftentimes, data that you want to analyze is spread across multiple sheets and multiple files. If you want to combine tables found on multiple worksheets and/or multiple worksheets, these four different techniques will help you join them together. Each technique results in different output. Choose the one that works best for you.

These methods are meant for data with like headers and data types.

Combine tables using UNIQUE
Four circumstances covered
  • Keep Original Order
    • Keep the order of the original data by stacking each list.
  • Sorted
    • Sort the resultant table by any column.
  • Duplicates removed
    • Remove any duplicate lines of data if you don’t want them in your sample.
  • No blank rows
    • Remove any blank rows from your new table.

Also, data from another file can be pulled into these formulas using the IMPORTRANGE function.

 Live examples in Sheets

Go to this spreadsheet for examples combining data.