I have a concat formula returning me a comma separated list of names in a cell

=concat(A2:A10 & " ,") returning [john, jack, jill] in the cell

Is there a way to add to this formula to expand to

john
jack
jill

in a column like that above?

CodePudding user response：

You can change the separator to be a line break =CONCAT(A2:A10 & CHAR(10)) or =TEXTJOIN(CHAR(10),TRUE,P3:P5)

The target cell needs to be set to Wrap Text for the line breaks to be displayed correctly.

CodePudding user response：

I used Power Editor to convert the cell into rows