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:

Column A      Column B                   Column C                   Column D
1235555       Company A (50%)       Company B (50%) 
1235556       Company A (100%)
1235557       Company A (33%)       Company B (33%)        Company C (33%)

Should actually be like this:

Column A       Column B
1235555        Company A (50%)|Company B (50%) 
1235556        Company A (100%)
1235557        Company A (33%)|Company B (33%)|Company C (33%)

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