Concatenate cells based upon adjacent cell

Question

A sample of my data is below:

I would like to concatenate all location numbers that have the same acronym.  So the output I am looking for would be the following:

NOS0654; 1661NOSM0654NOSW0654PAA0636; 0654; 0781

What is the best way to do this?

Thank you.

apathetichell · Accepted Answer

summarize tool - group by acronym. concatenate location no. - set ; as your delimiter.