Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Aug 09, 2022
Solved

combine two ranges vertically

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? 

Resources