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

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

Example 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.

CodePudding user response：

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

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