I have an example where columns to be masked in a table as duplicate. in the below example James Smith record has two entries, the requirement is to mask first_Name and Last_Name
First_Name Last_Name Department_name Category
James Smith HR Manager
James Smith IT Manager
Nate Carlos IT Lead
after masking, the output should look like this
First_Name Last_Name Department_name Category
Richard Williams HR Manager
Richard Williams IT Manager
Greg Chapel IT Lead
any suggestion, on how to build custom defined function. or Any inbuilt in function that take care of it