Join/Collect Formula to Create a Dropdown List

Options

I am trying to create a dropdown list that is using the join/collect formula. I have the following data in the reference sheet, but want the dropdown list in my main data table. Is this possible?


Answers