Join Collect multiple columns from another sheet
I have this growing reference sheet with Site_Name and respective emails (1-3). Not all of them have all 3 emails. Please also assume that the emails are not beside each other. They could be 2-3 columns apart.
I need to merge their emails on this order tracker, but not sure how to use Join Collect if there are multiple columns.
Help Article Resources
Check out the Formula Handbook template!