Forum Discussion
Sort 2 columns into 1
Hey, I'm trying to port some of my google sheets into excel, and I'm finding that there are many simple things that are just not working For example, I have two separate columns each filled with dat...
The easiest move is to convert the 2-column array into a single column, remove dupes, and sort.
This is the idea:
=SORT(UNIQUE(TOCOL(B2:C10)))