Combining multiple rows with common fields

[ltensmeyer]

I'm trying to find the most efficient way to take information like this:

First Name    Last Name  Details

Ethan	Klein	Dental Benefits
Ethan	Klein	Medical benefits
Ethan	Klein	Family plan
Lauren	May	Family plan
Lauren	May	Medical benefits
Lauren	May	Home benefits
Lauren	May	Dental benefits
Lauren	May	Childcare benefits
Jacob	Horan	Dental Benefits
Jacob	Horan	Medical Benefits
Josh	Forbes	Medical Benefits

and create one row for each person, combining each of the different details into one chunk of text divided by commas. 

The goal is to get something like this:

First Name Last Name Details

Ethan	Klein	Dental Benefits, Medical Benefits, Family Plan
Lauren	May	Family plan, Medical benefits, Home benefits, Dental benefits, Childcare benefits
Jacob	Horan	Dental Benefits, Medical Benefits
Josh	Forbes	Medical Benefits

One of my bigger problems is the fact that each person will have a different number of rows, so I can't just set a number of rows to combine, I have to check and make sure the first and last names are matching.

Any ideas are appreciated, thank you!

[Yoshiro_Fujimori · Accepted solution]

@ltensmeyer ,

"Concatenate" Action in Summary tool may work for you.

Input Data

Configuration in Summary Tool

Output Data