In the data mesh tool, it's frustrating that it only matches the first entry. There should be an option to match all duplicates.
We often have sheets that need to pull data from Sheet A into Sheet B. There might be duplicates on sheet B, and we want that data from Sheet A to be available for all instances of that match on sheet B.