This function appends ranges vertically and in sequence to return a larger array.
Academy ↓
Formulas > =VSTACK()
How To Use VSTACK() Function in Google Sheets
Description
How To Actually Use VSTACK() in Sheets
VSTACK(range1; [range2, …])
1Better Sheets Tutorial
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.
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.
Asa
Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.