Google Sheets - Use UNIQUE function and display as a row

Question

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?

Answer 1

You can use this:

=TRANSPOSE(UNIQUE(E1:E7))

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

Functions used:

• TRANSPOSE
• UNIQUE