I have two sheets.
Sheet 1 contains a multi-select location list.
Sheet 2 contains contacts for each location on sheet 1
For sheet one, I need a list of all related contacts (from sheet 2) that correspond with the list of locations (sheet 1).
I have tried to use a Join-Collect function but with no success.
Is there an issue with Join/Collect functions with multi-select dropdown columns?
Suggestions?