How to combine two sheets and merge duplicates? |
In this tip, We are going to explore:
How to combine two sheets and merge duplicates?
All explanations are simple and to the point.
#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets
Feel free to make your copy of this spreadsheet (Sheet 07A 07B 07C):
https://docs.google.com/spreadsheets/...
If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded
Useful Link:
Google Workspace Tutorial:
/ googleworkspacetutorial
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
The Playlist link:
• The most useful Google Apps Tips and ...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
The tip inspired from:
https://stackoverflow.com/questions/5...
On this sheet, we have this table.
And this one on another sheet.
To combine them and merge duplicates, we use the QUERY function.
QUERY({'07A'!A:B;'07B'!A:B},"SELECT Col1,SUM(Col2) WHERE Col2 IS NOT NULL GROUP BY Col1 LABEL SUM(Col2) 'Quantity'",1)
We join the sheets together.
Select the columns that return.
Remove the empty rows.
Group by the first column.
And change the header of the second column.
Type 1 for the headers.
And here is it.
