I have a spreadsheet where I am trying to grab all unique names in Column "presenters". The issue is that sometimes there are 2 or more presenters with a plus symbol in between.
My attempt: =UNIQUE((QUERY(importrange("1RmRiI-nG_Dy_zWO1XdJfcRIxAhllvMIPj9RdV79xi1g", "data!C2:C"))))
You can try this formula for your desired result
=UNIQUE(ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(JOIN("+", data!C2:C), "+")))))