This function appends ranges vertically and in sequence to return a larger array.
Formulas > =VSTACK()
How To Use VSTACK() Function in Google Sheets
Description
How To Actually Use VSTACK() in Sheets
VSTACK(range1; [range2, …])
1 Better Sheets Tutorial
Vertically Stack and Sort Data
It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.
VSTACK()
SORT()
Learn more about the VSTACK() formula:
Generate a VSTACK() formula for your needs with AI
Google Sheets Formula Generator
Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.