Standarize Column Using Common Data of Other Column

[araquecastro]

Hi People. I have the dataset attached. My challenge is to find a way to avoid the column Employee Name to have different Data when Column Emp Init is the same. In this case I have Emp Init = MT1 but Employee Name has different results:

Report	Emp Init	Employee Name
TRUNK001	MT1	PELLETIER, MIA
TRUNK001	MT1	PELLETIER, MIA
TRUNK001	MT1	PELLETIER, MIA
TRUNK001	MT1	PELLETIER, MIA
TRUNK001	MT1	PELLETIER, MIA
TRUNK001	MT1	PELLETIER-THERRIEN
TRUNK001	MT1	PELLETIER, MIA

I want to change Employee Name to PELLETIER, MIA as it is the one with more results, but I don't want to hardcoded I would like to have a formula or expression that can work for any other future situation like this. I'm aware that the best way is to request a clean data from stakeholder but I'm in a rush and would like to find a shortcut if possible.

I really appreciate the support you can provide.

[cjaneczko]

Here is one way.

[araquecastro]

Thanks @cjaneczko for the quick reply. Can yo please share the workflow?

Thanks in advance again

[cjaneczko · Accepted solution]

Here you go.

[araquecastro]

Thank you @cjaneczko  it worked perfect marked as solution.