To split cells vertically, select the cell where you need the result (A3), go to the Formula bar, and type the following formula:
=TRANSPOSE(SPLIT(A1,”,”))
How do I split cells vertically in Google Sheets
Then hit the Enter key on your keyboard.
How to split cells vertically in Google Sheets
The text has now been split up vertically rather than horizontally.