Here I am using the function Query (please don’t let the function name to scare you) to merge two tables in Google Sheets. Merge Data Based on Unique IDs and Add Amount Column (Type 1) There are only a few lines of sample data to type. If there is no domain level restriction to receive an outside file, you can successfully copy it. I know it will be time taking for you to make the demo sheet. I am going to detail the above three types of merging of datasets below.
This time, for the example, I am using a sample sales data, not the employee salaries. So I thought of including all the possible variations.īelow I am merging two tables in a unique way! It’s by searching the column header and then combining the matching columns.
This is an ultimate guide on how to merge two tables in Google Sheets. See Type 3 below and then we can go to the formulas. I hope the above table (merged) can well explain what I meant. Let me take your attention to the last two columns of the merged table. But instead of adding their salary amount (see the above screenshot), you may want to place that in a new column as below.
Of course, here again, you want to merge the duplicates. Sometimes you may want to merge two tables differently as below. Of course, the solution will be formula oriented. I will give you the formula and step-by-step instructions on how to merge two tables as above in Google Sheets. The unique IDs are also added to the merged table as a new row. It was like merging the duplicates in the first two columns and then adding the net salary (third column). In the above example, I have merged two tables. I usually merged those tables into one to make a three months summary report of employee salary. It was related to the quarter ending so there were three reports, you can say three tables. I had been presented monthly salary reports of employees on a quarterly basis. You May Like: Google Sheets vs Excel – Comparison of a few functions in both. Different Types of Merging of Two Tables in Google SheetsĪ couple of years back, I used to merge tables in Excel (yes! that time I was using Excel) as part of our quarter ending financial statements. Note: Open this functions guide in a new tab as you can quickly refer to any functions that I am going to mention below. In this tutorial, I have included 3 different types of merging of tables. The types and purpose of the merging of two tables may be different for you. Yes! I am going to take into consideration different aspects of merging of tables. This tutorial may be a little lengthier as I have included different types of merging of tables. It’s about how to merge two tables in Google Sheets using formulas. No script, no add-on! I am back with another Google Spreadsheets tutorial.