How to split cell vertically in Google Sheets

You can easily split cell vertically using the TRANSPOSE and SPLIT function in Google Sheets.

1. To split cells vertically, use this formula:
   =TRANSPOSE(SPLIT(A1, " "))

A1 – This should be your data
   " " – This is the delimiter that determines where to split the text. In this example, I am using a blank space.
2. In this second example, I an using "," as a delimiter.
   =TRANSPOSE(SPLIT(A11, ","))