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

tbrynard01

Board Regular
Joined
Sep 20, 2017
Messages
73
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
 
Last edited:

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,883
Office Version
365
Platform
Windows
Try using the TextJoin function instead. That enables you to ignore blanks & specify a delimiter
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,883
Office Version
365
Platform
Windows
My pleasure.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,978
Messages
5,411,627
Members
403,383
Latest member
Excelacity

This Week's Hot Topics

Top