Collect values in multi-select field from different lookup sheet
I have two sheets. The first sheet (destination sheet) has the multi-select column 'Value', and the second the values I want to collect based on Project ID (unique identifier) between sheets. The unique identifier could appear more than once, so incorporated the Row ID in lookup sheet if required.
I don't think the helper row is required but just added it.
The result I am looking for is depicted in the 1st screenshot below.
Some assistance will be appreciated.
Help Article Resources
Check out the Formula Handbook template!