combine two ranges vertically

[ajl_ahmed]

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? 

[#2 · Accepted solution]

@ajl_ahmed 

Depends on which channel you are. That could be

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

[#3]

Many thanks

[#4]

@ajl_ahmed , you are welcome