Create a list from TRIM CONCAT

[NVRensburg]

I have this formula which works perfectly, however it lists the names from column K one next to the other. I want to list the names one under the other in the cell. What can I add to this formula to achieve that please?

=TRIM(CONCAT(IF(ISBLANK(K58:K139),C58:C139,"")&" "))

Thank you in advance!

 

[MountainFog]

Can you post a screenshot of what your desired output is?

 

[Jamerzzzz]

Hi, use the CHAR(10) character for a carriage return/line break
=TRIM(CONCAT(IF(ISBLANK(K58:K139),C58:C139,"")&Char(10)))
Then apply 'Wrap Text' to the cell

 

[Scott Huish]

In Excel 365 which you have listed, you could also do this:
=TEXTJOIN(CHAR(10),,FILTER(C58:C139,K58:K139=""))

Apply Wrap Text to the cell.

 

[NVRensburg]

Thank you so much, this one worked!

In Excel 365 which you have listed, you could also do this:
=TEXTJOIN(CHAR(10),,FILTER(C58:C139,K58:K139=""))

Apply Wrap Text to the cell.

 

[Alex Blakenburg]

If you are only using 365 please update your profile. Filter won't work in 2016 and I don't think TextJoin will either.