Find Duplicate Values in a column and compare values in another column

[Aaron_Bowen]

Hello, 

I have a workflow that is combining multiple data streams. Duplicate values are found in one of the columns: 

In another column there are Network IDs that are different:

I need to keep the row that contains the most Network IDs while eliminating all of the other rows. Not sure how to best accomplish this. Can someone please help? The end product should be a single row for Row Number "AZ-000867" with the Network IDs "AZN003, AZN007, AZN002."

Thanks, 

AB

[Clifford_Coon · Accepted solution]

Hi @Aaron_Bowen ,

Here is one way:

Count the number of Commas in the ID field

Sort by Count (decending)

Sample the first of each row

 

[Aaron_Bowen]

Thank you so much! Worked like a charm. :)