Google sheets array formula to split and transpose cells with commas into another column

Question

I'm looking for an arrayformula to split and transpose all comma-separated values into a single column.

See my sheet here:

score 1 · Accepted Answer · answered Dec 09 '19 at 16:51

1

try:

=TRANSPOSE(SPLIT(TEXTJOIN(",", 1, A:A), ","))

answered Dec 09 '19 at 16:51

player0

1 Answers1