You can use the following formula in Google Sheets to split a cell vertically into multiple cells:

=TRANSPOSE(SPLIT(A2, ", "))

This particular formula splits the values in cell **A2** vertically into multiple cells, using a comma as the delimiter to determine where to split the values.

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

**Example: How to Split a Cell Vertically in Google Sheets**

Suppose we have the following list of basketball team names in cell **A2** in Google Sheets:

Suppose we would like to split the team names in this cell vertically into multiple cells.

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

=TRANSPOSE(SPLIT(A2, ", "))

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

Column C now contains each of the individual team names from cell **A2** split into multiple cells vertically.

**How This Formula Works**

Recall the formula that we used to split the text in cell **A2** into multiple cells vertically:

=TRANSPOSE(SPLIT(A2, ", "))

Here is how this formula works:

First, we use the **SPLIT** function to split the text in cell **A2** into multiple cells horizontally based on where the commas occur in the cell.

Next, we use the **TRANSPOSE** function to convert the horizontal output to a vertical output.

The end result is that we’re able to split the values in cell **A2** into multiple cells vertically.

Note that you could also specify a different delimiter to use besides a comma if the text values in your cell are separated by a different delimiter.

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

**Additional Resources**

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

Google Sheets: How to Use SPLIT with Multiple Delimiters

Google Sheets: How to Split Date & Time

Google Sheets: How to Use SPLIT Function and Get First Item