Sort two columns into one list

[rmrossetti]

Hello! Is there a way to sort the data in columns 1 and 2 into one unique list in column 3?

Employee List	Contractor List
Ethan Hunt	Andy Reid
John Wick	Steve Buscemi
Allen Iverson	Billy Crystal
Pete Rose	Mike Justice
Jalen Hurts	Chris Max

 

[AhoyNC]

What version of Excel do you have?
If you have Excel 365 or 2021 then try"

Book2
	A	B	C
1	Employee List	Contractor List
2	Ethan Hunt	Andy Reid	Steve Buscemi
3	John Wick	Steve Buscemi	Billy Crystal
4	Allen Iverson	Billy Crystal	Ethan Hunt
5	Pete Rose	Mike Justice	Jalen Hurts
6	Jalen Hurts	Chris Max	Allen Iverson
7			Mike Justice
8			Chris Max
9			Andy Reid
10			Pete Rose
11			John Wick
Sheet1

Cell Formulas
Range	Formula
C2:C11	C2	=UNIQUE(SORTBY(TOCOL(A2:B6,1),TEXTAFTER(TOCOL(A2:B6,1)," ",-1)))
Dynamic array formulas.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[rmrossetti]

OK, thank you! It looks to have combined the list, but not sorting in alphabetical order.

 

[Fluff]

Can you answer my question & update your profile?

 

[AhoyNC]

Also, how do you want to sort (I sorted by last name)?