Forum Discussion
Jam8
Aug 10, 2025Copper Contributor
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...
HansVogelaar
Aug 11, 2025MVP
For non-adjacent columns:
=SORT(UNIQUE(TOCOL(VSTACK(B4:B100, G4:G100), 1)))