You can use the **VSTACK** function in Google Sheets to stack multiple columns into one column.

For example, you can use the following formula to stack the values in the first seven rows of columns A, B and C into one single column:

=VSTACK(A1:A7, B1:B7, C1:C7)

The following example shows how to use this formula in practice.

**Example: Stack Multiple Columns into One Column in Google Sheets**

Suppose we have the following three columns of values in Google Sheets:

Suppose we would like to stack the values in these three columns into one single column.

We can type the following formula into cell **E1** to do so:

=VSTACK(A1:A7, B1:B7, C1:C7)

The following screenshot shows how to use this formula in practice:

We can see that the **VSTACK** function has successfully stacked each of the columns into one single column.

Note that the **VSTACK** function also works if there are a different number of values in each column.

For example, we could use the following formula to stack multiple columns into one column when there are a different number of values in each column:

=VSTACK(A1:A7, B1:B3, C1:C5)

The following screenshot shows how to use this formula in practice:

The **VSTACK** function has successfully stacked each of the columns into one single column.

**Note**: You can find the complete documentation for the **VSTACK** function in Google Sheets here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Split Text into Rows

Google Sheets: How to Combine Date & Time

Google Sheets: How to Check if Cell Contains Text from List