Merging certain columns in duplicate rows.

[DanMBrx]

Hi, 

I am wondering if a workflow would be possible to solve this. 

I want to merge a certain column when a duplicate occurs. I have attached an image explaining what I mean, the top two rows are examples and the lowest row is the outcome I’d like. Obviously on a larger scale than this. 

thanks.

Dan

[BS_THE_ANALYST · Accepted solution]

Hi @DanMBrx! See the attached before and after picture. 

You can achieve this with the summarize tool! 

[ShankerV]

Hi @DanMBrx 

Please use summarize tool to achieve the solution.

Many thanks

Shanker V

[DataNath · Accepted solution]

Hey @DanMBrx, concatenating unique values is a good discussion and there's some ideas suggested for this on the forums. For now, here's a dynamic way of handling this that could also scale to N number of fields if you scale out rather than down:

[ShankerV · Accepted solution]

Hi @DanMBrx 

Please find the use case to explain it.

It will work on huge dataset also.

Please select Group By on the Column where you feel duplicates and use the Concatenate on the column to be merged.

The default will be separator , where it can be replaced with anyother as per would interest.

Many thanks

Shanker V

[DanMBrx]

Brilliant thank you guys, that was quick!