How to Concatenate multiple Rows into 1 Column cell

[rbapdx]

Hi,
We are trying to merge multiple client databases into one data file. Currently we have merged all data together in the attached (sample) file, which lists each row by client first and last name with a comments field for each row. We are wanting to combine all the rows related to a single client name into one while combining the comments field into one cell for each individual client.. In the attached file I have notated the clients first/last name and comments field in yellow, and the location of the combined comments field in red.

Does anyone know the best way to accomplish this matter?

Thanks in advance.


Forum upload sample file.xlsx

[JapanDave]

I am not sure if this is what you need. But if all you are doing concatenating, then this attached file does that.

[rbapdx]

JapanDave,
Thanks for taking a look and sending a sample file. This is not quite what I am looking for. Let me try to better explain myself.

Example of from the attached file what we are trying to accomplish:
Client #1 (Jeff ?) =rows 4-8, we want to combine Lead Comments H4-H8 and display result in cell I4.
Client #2 (Scott Elliot) =rows 9-20, we want to combine Lead Comments H9-H20 and display in cell I9.
Cient #3 same as above

Currently our database has 58,000 (rows) records with each client ranging from 1 to 20+ rows. We are wanting to combine the comments and then delete the duplicate records. Due to the number of records we are looking for a formula to assist in the combining and filtering.

Again your help is appreciated if you have a solution.

Thanks,

[jindon]

try

Please Login or Register  to view this content.

Edit:
Code has been edited after seeing your last post.

[rbapdx]

jindon,
Thank you for sending the code, it works well. I previously only sent a edited file as a test as I am new to the forum. I have been unable to edit the formula correctly for the actually data file. Can you please look to see what changes need to be made as the Column is (am) in out data file not (i).

I am attaching file for reference.

Forum upload sample file 2.xlsx


Thanks again for your help.

[jindon]

Change to

Please Login or Register  to view this content.

[rbapdx]

jindon,
Thank you very much, this accomplished what we needed.

Thanks again...

[jindon]

Your are welcome.