combine several rows to one if column A matches

[s@skia]

Hello, this is probably a problem already solved somewhere but I couldnīt find it because the right keywords eluded me:

I want to combine the strings in the column B (using ; as separator) if the identifier in column A is the same
columnA columnB
CE00004 IPR000911
CE00004 IPR020783
CE00004 IPR020784
CE00015 IPR004365
CE00015 IPR004523
CE00034 IPR004911

columnA columnB
CE00004 IPR000911;IPR020783;IPR020784
CE00015 IPR004365;IPR004523
CE00034 IPR004911

Thank you

[XOR LX]

Hi,

Are you insistent on concatenating the results into a single cell or would you be satisfied with returning each match in its own column to the right?

The latter would be relatively straightforward, though, unless you have a reasonably small upper limit on the maximum number of matches for any one identifier, the former will require either some unfeasibly long formulae or a VBA-based solution.

Regards

[s@skia]

Yes unfortunately other columns are adjacent to the column I want to combine which will be problematic if every entry gets itīs own cell.

[XOR LX]

Fine, then I trust someone with some VBA expertise will pick up on this thread shortly.

Regards

[AB33]

The output is in new sheet.

[s@skia]

Sorry for the late reply. The script works for me, thank you!