I feel that the Unique function doesn’t work the way I expected.
when I use =Unique(K2:K)
it puts the results into a comma separated cell:
instead of a column list:
I then tried to transpose the results, but that gave me an error about not being able to get any values, i think because it’s a formula in the cell.