I have a column and each cell has multiple labels, like so:
a,b,c
b, c, d
g, h, a
So I'm looking for a formula, not code, where the formula finds the unique elements for the column,
output:
a
b
c
d
g
h
I've tried different combinations of unique()
, split()
, arrayformula()
, transpose()
but can't get it work.
=unique(ArrayFormula(TRANSPOSE(split(A1:A3,","))))
not sure how to get it into one column