Excel formula not working - returning unique values horizontally

Question

Is there a way to display unique values from my dataset horizontally WITHOUT using the transpose function:

I have a table like this from G6-G15:

**Colour**
Red
Red
Blue
Green
Green
Green
Yellow
Yellow
Yellow

My required output is this

Blue Green Red Yellow

I have tried using this formula to return the unique values horizontally however, it doesn't seem to work =INDEX(SORT(UNIQUE($G$7:$G$15)),COLUMN(G6))

question from:https://stackoverflow.com/questions/65924989/excel-formula-not-working-returning-unique-values-horizontally

Answer 1

We can use SEQUENCE to SPILL right:

=INDEX(SORT(UNIQUE($G$7:$G$15)),SEQUENCE(,COUNTA(UNIQUE($G$7:$G$15))))

---

Or we can do the old fashioned drag with:

=INDEX(SORT(UNIQUE($G$7:$G$15)),COLUMN(A1))