Unique Function format

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:
2021-02-22 12.23.24 app.spreadsheet.com edef4060f0ab

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.

I believe this will be fixed alongside our larger Array formula support - The ability to spill an array like result into a column of cells. I will be updating this thread.

2 Likes