Struggling to Merge Two Different-Sized Tables into a Third Table
What I'm trying to achieve is combining two different-sized tables into a third that groups together duplicates. I've provided the methods that I've attempted thus far and their results in the sheet linked below.
Sample sheet: https://docs.google.com/spreadsheets/d/1vbYTL1hnh_-HNY0RL9w5yAR920zPxouG4jwsNX-MyC4/edit?usp=sharing