Group Multiple values from different rows into one row based on common identifer

[Masond3]

Hi Team, 

This is hopefully a easy ask 

Where there are multiple entities (Rows) for a given "Comp Id" then append the names from the different rows  together (Separated by a semicolon )  against a given Comp ID

Input 

Comp ID	Name
11111	John Doe
11111	Silver Fox
22222	Grey Goose

Expected Out put 

Comp ID	Name
11111	John Doe ; Silver Fox
22222	Grey Goose

Looking forward to your help 

Many Thanks 

Regards

Masond3

[ShankerV]

Hi @Masond3 

You can achieve your goal by Summarize tool.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Masond3 

Output:

Summarize tool- 

Many thanks

Shanker V

[ShankerV]

Hi @Masond3 

Very important, usually the concatenate Separator in default will be ,

Kindly modify as ; to get your output.

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[Masond3]

I was trying to do this in cross tab :) 
Thanks the pointer - really appreciate it