Combining multiple columns into single range

Question

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)

player0 · Accepted Answer · 2019-03-13 16:50:26Z

1

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

answered Mar 13, 2019 at 16:50

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TRex Over a year ago

thanks @player0. That was exactly what I was looking for. I was using the {;;} grouping incorrectly.

player0 · Accepted Answer · 2019-03-13 16:54:02Z

1

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

answered Mar 13, 2019 at 16:54

player0

131k14 gold badges91 silver badges149 bronze badges

Collectives™ on Stack Overflow

Combining multiple columns into single range

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related