Hi! I have the below Input and Output data for possibly concatenating across Multiple Rows. I am not sure that fits this workflow, but looking for any guidance! Thanks Input Client NameAddressDuplicateJames123 Starlight LaneYesChristopher123 Starlight LaneYesSteven456 Milky WayYesDavid456 Milky WayYesJed456 Milky WayYesNehemiah789 Aurora BlvdNoSam101 Dipper StreetNo Output Client NameAddressMailing LabelJames123 Starlight LaneJames, ChristopherChristopher123 Starlight LaneJames, ChristopherSteven456 Milky WaySteven, David, JedDavid456 Milky WaySteven, David, JedJed456 Milky WaySteven, David, JedNehemiah789 Aurora Blvd Sam101 Dipper Street

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Concatenate multiple rows

chris4987

Hi! I have the below Input and Output data for possibly concatenating across Multiple Rows. I am not sure that fits this workflow, but looking for any guidance! Thanks

Input

Client Name	Address	Duplicate
James	123 Starlight Lane	Yes
Christopher	123 Starlight Lane	Yes
Steven	456 Milky Way	Yes
David	456 Milky Way	Yes
Jed	456 Milky Way	Yes
Nehemiah	789 Aurora Blvd	No
Sam	101 Dipper Street	No

Output

Client Name	Address	Mailing Label
James	123 Starlight Lane	James, Christopher
Christopher	123 Starlight Lane	James, Christopher
Steven	456 Milky Way	Steven, David, Jed
David	456 Milky Way	Steven, David, Jed
Jed	456 Milky Way	Steven, David, Jed
Nehemiah	789 Aurora Blvd
Sam	101 Dipper Street

Accepted answers

messi007

@chris4987,

Please see below

I did it using the concatenate function in the summarize tool 🙂

Attached the workflow,

Hope this helps!

Regards

Concatenate_20210426.yxmd

All comments

Luke_C

Hi @chris4987

The summarize tool should be able to help you. See below screenshot with configurations. It will let you concatenate based on common fields, in this case address.