Duplication rows

[Ranjan88]

Hi Team,

I have multiple row data where there are duplicates I need them to be deleted and I need one of the columns should be updated with the original row.

This is my data where it's duplicated based on the Engagement id.

Engagement ID	PE Anchor
1937	Assurance
1937	Sat

I need this to be in one line and PE Anchor should be a combination of my original and duplicated line.

Engagement ID	PE Anchor
1937	Assurance/Sat

Regards,

Ranjan

[JosephSerpis]

Hi @Ranjan88 you can use a summarise tool to concatenate a field.