How to append string under one column

[blitz45]

Hi, 

I need help on how to append the employee IDs that are working at the same company. Please see below.

What I currently have: 

What I would like my final results to look: 

[atcodedog05 · Accepted solution]

Hi @blitz45 

Here is how you can do it.

Workflow:

Hope this helps : )

[blitz45]

@atcodedog05 I was thinking too hard, LOL :) Thank you!

[atcodedog05]

Happy to help : ) @blitz45 

Cheers and have a nice day!