I have a dataset with a column FY which has years FY21 to FY24 and 3 different ID's and 3 different names for all 3 ID's like position code, Position name, incumbent ID, Incumbent Name, Successor ID & Successor name, now I want to change the names for all these 3 to the latest ones which are in FY24(over the years names changed like removing middle names, or adding initials etc.). I do have lot of duplicates in this based on the position, and successor for the given incumbent etc. so I need help in changing names to latest one's, I tried using join but if I join just with Incumbent ID I'm getting 50K+ data for the given 9000+ input and if I did with all three code matches if the successor is different it's leaving the empty spaces
