Replace words in specific column to summarize

johnnyycchan

Hi all,

There are some data in the column to replace some words based on criteria in priority (from left to right) as follow : 

BP --> Recall --> OS --> GOV --> Commercial --> FC --> Other Service

Source : 

Customer	Type
David	BP
Tom	Commercial
David	GOV
Mary	Recall
Susan	OS
Jim	FC
Susan	Other Service

Output : 

Customer	Type
David	BP
Tom	Commercial
Mary	Recall
Susan	OS
Jim	FC

Best Regards,

Johnny

AngelosPachis

Hi @johnnyycchan ,

With a formula tool, I have created a new column with the Priority ID. Then I sorted for each customer, so the smallest ID comes first and with a summarize tool I just kept the first value.

Hope that helps, let me know if that worked for you.

Cheers,

Angelos

example.yxmd