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?

CodePudding user response：

try this:

=UNIQUE(FLATTEN(A1:D1))

CodePudding user response：

You can use this:

=TRANSPOSE(UNIQUE(E1:E7))

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

Functions used:

• TRANSPOSE
• UNIQUE