Google Sheets - Use UNIQUE function and display as a row

AJ Jain 0
Viewed 19

In google sheets, using UNIQUE on a column causes all of the unique values to be displayed in a column.

Is there a way to have all of the values displayed in a row instead of a column?

google-sheets-formula google-sheets
2 Answers

try this:

=UNIQUE(FLATTEN(A1:D1))
player00

You can use this:

=TRANSPOSE(UNIQUE(E1:E7))

(Do adjust the formula according to your ranges and locale)

enter image description here

Functions used:

marikamitsos0
Related