Hello, I am looking for a formula or a formatting solution to move comma-space separated, text/number, field values to a multi-select dropdown field this way when I am filtering my final report, I can use a "has any of" filter instead of having to use separate "contains" filters to find the information I need. See below example:
Something to note is that in my real spreadsheets, I have as many as 15-20 values in a particular field and as few as 0, so the solution will need to account for that as well.
