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 IDName11111John Doe11111Silver Fox22222Grey Goose Expected Out put Comp IDName11111John Doe ; Silver Fox22222Grey Goose Looking forward to your help Many Thanks Regards Masond3

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

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

Common Use Cases

Accepted answers

ShankerV

Hi @Masond3

Output:

Summarize tool-

Many thanks

Shanker V

All comments

ShankerV

Hi @Masond3

You can achieve your goal by Summarize tool.

Many thanks

Shanker V

ShankerV

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280