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))
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))
1.4m articles
1.4m replys
5 comments
56.9k users