CODEWITHSUNDEEP
excelexcel-formulaunique
frickinFrodo
frickinFrodo

Reputation: 99

Extract unique values from horizontal row and spill down in a list vertically

I have many values in row 5. I want to extract the unique values in row 5, and present them in a vertical list.

When I throw a unique-formula on row 5, the list is created horisontally sideways, not downwards.

The scenario is described in this picture: Picture link

Upvotes: 1

Views: 541

Answers (1)

Terio
Terio

Reputation: 507

Use TRANSPOSE

=TRANSPOSE(UNIQUE(row5,1))

or

=UNIQUE(TRANSPOSE(row5))

where row5 is your range,

Upvotes: 1

Related Questions