Find if duplicate values exist in a column, concatenate cells and then de

Hello Jerry,

Thank you for this script, it's extremely helpful! If I wanted to concatenate all the values in the rows from Column B onwards with a pipe symbol between them how would I do this? So using the OP's data:

This:

Please Login or Register  to view this content.

Should actually be like this:

Please Login or Register  to view this content.

I can do it manually of course by concatenating the columns, but if this could be automated in the script it would be much better.

Regards

Paul

When you joined the forum you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)

Here's a macro for merging rows of data using the ID in column A and putting the column B values together in a delimited manner of your choosing. There's a sample file as well for testing.

Merge Rows

There's a sample workbook too you could drop your data into and test it out.