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...
Use the SORT function to merge two columns and sort them：
=SORT(CHOOSE({1,2}, A2:A100, B2:B100), 1, 1)You can also copy the two columns to a new column → sort by the new column With VBA automation:
Range("C1:C200").Value = Application.Transpose(Array(Range("A1:A100"), Range("B1:B100")))
Range("C:C").Sort Key1:=Range("C1"), Order1:=xlAscending