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
