Help: concatenate, skip blanks, add line break

Hello,

I am looking for help on writing a formula that will concatenate cells, ignore blanks, and add line breaks on those that do not have blanks.

The data: I have a list of people and they have different meetings they need to attend. I want to concatenate all their meetings into one cell, with line breaks, but ignore the blank cells.

Final result wanted in one cell:
Meeting 1
Meeting 3


I can't seem to upload a file I keep receiving an error. Let me know if you need more info

Try this in E2:

=SUBSTITUTE(IF(B2="","",B2&CHAR(10)) & IF(C2="","",C2&CHAR(10)) & IF(D2="","",D2&CHAR(10))&"$",CHAR(10)&"$","")

then copy down. Note that Excel is not very good at maintaining the appropriate row heights, so you may have to adjust some manually.

Hope this helps.

Pete

This is perfect! Thank you so much for the speedy response!

Can you let me know which section of this formula gets duplicated to include more cells? My actual data runs from cell B2 to FZ2. This is over 180 cells I need to combine :/