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 · Accepted solution]

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

[johnnyycchan]

Hi Angelos,

It works. Thanks a lot. 

Best Regards,

Johnny