Formulas > =VSTACK()

How To Use VSTACK() Function in Google Sheets


This function appends ranges vertically and in sequence to return a larger array.

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.


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.