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

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

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

Time：09-22

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

CodePudding user response：

Use TRANSPOSE

=TRANSPOSE(UNIQUE(row5,1))

=UNIQUE(TRANSPOSE(row5))

where row5 is your range,