CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Jerry
Jerry

Reputation: 107

How to split string into multiple columns then stack into one column?

=ARRAYFORMULA(SPLIT(C2:C22," "))

How can I combine the output of this formula into one column vertically?

Example output:

output

**Note: I'm not looking to combine strings to fit in a single cell. I'm looking for every value to be stacked vertically.

Upvotes: 0

Views: 250

Answers (1)

Gangula
Gangula

Reputation: 7294

You can use the FLATTEN formula to convert the output into a vertical list:

=FLATTEN(ARRAYFORMULA(SPLIT(C2:C22," ")))

Upvotes: 1

Related Questions