combine data from one column into one cell based on a criteria

[tbrynard01]

I have a column that has comments and I would like to combine those comments into one cell which =concat does but how can I add a comma and space between the comments from each line

Column 1 = Topic Column 2 = Comment

Not every row has a comment though

Your help would be greatly appreciated

 

[Fluff]

Try using the TextJoin function instead. That enables you to ignore blanks & specify a delimiter

 

[tbrynard01]

Thank you

 

[Fluff]

My pleasure.