combine two ranges vertically

Frequent Contributor

I have two ranges (range 1, G5:K12) and (range 2, N5:R8). I want to combine these two ranges vertically to construct a new range or table (Range 3, A5:E16) considering sorting the student names alphabetically. is there a formula or function to do that? 

3 Replies
best response confirmed by ajl_ahmed (Frequent Contributor)


Depends on which channel you are. That could be

=SORT( VSTACK( Range1, Range2 ), 2)
Many thanks

@ajl_ahmed , you are welcome