Table of Contents
To split a cell vertically in Google Sheets, follow these steps:
1. Select the cell or cells you want to split.
2. Click on the “Format” tab in the menu bar.
3. Select “Split cells” from the drop-down menu.
4. A pop-up window will appear, allowing you to choose the direction of the split (vertical or horizontal) and the number of new cells you want to create.
5. Click “Ok” to confirm the split.
This will divide the selected cell or cells into the specified number of new cells, vertically. This feature can be useful for organizing data and creating a more visually appealing spreadsheet layout.
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 .
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets: