Split a Cell Vertically in Google Sheets

---

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:

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 .