Merge two tables in Google sheets
Merge data from two sheets in 5 simple steps
This add-on simplifies the task of combining information you have in two different tables. It skilfully scans key columns in two sheets that you specify and pulls all the necessary updates into your main table. Even if the column order is different, all that matters is the key column with the same records. Follow 5 simple steps whenever you need to fetch some data from another table:
No formulas, no copy-pasting
Let the tool automatically match and update records in your sheet. Just make sure you define common columns in two sheets that the add-on should compare in order to find the same records, e.g. product IDs or student names.
Then decide if you want to pull updated records to any existing columns and if you need to add any new data to the right of the original table.
Match and update records
The last step of the wizard groups several additional options for adjusting the merge process. Here you can choose to bring changes only to the empty cells in your Master table and/or only from non-empty cells in your Lookup table, and use status column and color for the updated cells to see all the changes right away.
All records from the lookup table will be placed on the rows that correspond to their key value, e.g. the ID. If you have new records that are not present in your main sheet, you can have such rows copied to the end of the table.
Click Merge and see all changes transferred from another sheet; your table is up-to-date!