CODEWITHSUNDEEP
excel
MJobbson
MJobbson

Reputation: 171

Using Excel transpose data from column to row whilst also finding uniques

I have what seems to be an easy task but at the minute i'm stumped. I have a list of text values, say A1:A19, with multiple entries some of which are repeated in the list. I want to take the list in column A and copy to a row, say B2:B8, However i only want to move across each individual value once. Can this be done?

enter image description here

Upvotes: 0

Views: 394

Answers (1)

Darren Bartrup-Cook
Darren Bartrup-Cook

Reputation: 19837

UNIQUE returns the unique values from a range.
TRANSPOSE rotates cells from rows to columns or vice-versa.

=TRANSPOSE(UNIQUE(A2:A19))

enter image description here

Upvotes: 1

Related Questions