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.
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.
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.
Four circumstances covered
Keep Original Order
Keep the order of the original data by stacking each list.
Sort the resultant table by any column.
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.