CODEWITHSUNDEEP
google-sheets
TRex
TRex

Reputation: 55

Combining multiple columns into single range

I have a sheet with several lists of names like such:

A     | B     | C
Joe   | Steve | Mike
Steve | Dave  | Alex
Sarah | Mike  | Joe
Beth  | Jane  | Steve

I'm trying to consolidate all the names in those columns down to a single range (such as can be used by unique()) so that users can be selected from a dropdown. Adding a multi-column range to unique() returns a multi-column result based on the uniqueness of each multi-column row (i.e. if 'Sarah, Mike, Joe' above were repeated, that would filter down to a single entry in the results)

Upvotes: 1

Views: 48

Answers (2)

player0
player0

Reputation: 1

=UNIQUE(TRANSPOSE(SPLIT(TEXTJOIN(" ",1,TRANSPOSE(QUERY(TRANSPOSE(A:C),,50000))), " ")))

0

Upvotes: 1

player0
player0

Reputation: 1

=UNIQUE(FILTER({A1:A;B1:B;C1:C},{A1:A;B1:B;C1:C}<>""))

0

Upvotes: 1

Related Questions