ProductSolutionsTemplatesResources

VSTACK

Appends ranges vertically and in sequence to return a larger array. Learn more

Video field
Array

The VSTACK function takes one required argument (range1) and can take additional optional arguments (range2, …) separated by semicolons.

The VSTACK function is particularly useful when you have data in multiple columns that you want to combine into a single column. It's also useful when you want to combine data from non-contiguous ranges.

For example, suppose you have two columns A and B with data set 1,2,3 and 4,5,6 respectively. You can use the VSTACK function to combine the data into a single column as follows:

=VSTACK(A1:A3;B1:B3) This will return the following output in a single column: 1 2 3 4 5 6

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!