Google Sheets | VSTACK | Function | Example | Spreadsheet | Tutorial | Append Data Vertically

What does the Google Sheets VSTACK function do? It combines
one or more ranges into an array, with the second and subsequent ranges
stacked vertically and sequentially below the first. An use of VSTACK
function is to combine two or more ranges of data into a single range.
This spreadsheet tutorial gives the steps to use VSTACK with examples.

=====================================
Food & Health Series Using 2D Animation

All the Parts of How to Prevent Diabetes series is based on research findings.

How to Prevent Diabetes Part 1

How to Prevent Diabetes Part 2

How to Prevent Diabetes Part 3

How to Prevent Diabetes Part 4

How to Prevent Diabetes Part 5
=====================================

-------------------------------------
How to Use WRAPCOLS in Google Sheets?

Wrap data in a row into one or more columns:

-------------------------------------
How to Use WRAPROWS in Google Sheets?

Wrap data in a column into one or more rows:

-------------------------------------
How to Use CHOOSECOLS in Google Sheets?

Get the data from one or more columns, using CHOOSECOLS:

-------------------------------------
How to Use CHOOSEROWS in Google Sheets?

Extract one or more rows of data using CHOOSEROWS:

-------------------------------------
How to Extract Specific Data Using CHOOSEROWS and MATCH in Google Sheets?

Extract data pertaining to specific strings, using CHOOSEROWS and MATCH functions:

-------------------------------------
How to Use TO_PERCENT in Google Sheets?

Format numbers with percent symbol using the TO_PERCENT function:

-------------------------------------
How to Use XLOOKUP for Reverse Search in Google Sheets?

XLOOKUP can search for the search key in the regular or reverse order in the lookup range:

-------------------------------------
How to Use XMATCH in Google Sheets?

XMATCH returns the position of the specified search key in a row or column:

-------------------------------------

VSTACK Function Formula

=VSTACK(range1, [range2, …])

Start the formula with an equal-to symbol.

VSTACK is the name of the function.

range1 is the first range to which range2 will append.

range2 and others are optional.

range2 will append to to range1, range3 to range2, and so on.

Examples

Example 1

=VSTACK(G2:I3, G4:I6)

The function will return an array, combining the two ranges G2 to I3 and
G4 to I6. This range will append to the first range.

Example 2

=VSTACK(A2:C4,{"---","---","---"})

In this function, for range2 argument, an array with three elements is used.
The function will return the range A2 to C4 with the each cell of the range A2 to C5 filled with three dashes appended to the range A2 to C4.

Take a look at this video tutorial, which gives the steps to use the Google Sheets VSTACK function with examples.