Replace column values with the latest year value

[mlim0806]

Hi Community, 

I have a sample dataset that consists of Positions and Leaders for years 2021-2024. You'll notice that in the year 2024, the naming of positions and the format of the names have changed, but the position code and leader ID's remained the same. 

What I am looking to do is replace all the historical values with the latest 2024 value, and if this position and leader did not exist in previous years, then just use what is in 2024. In the attached I've included the sample dataset, and the desired output. Many thanks!!! 

[binuacs]

@mlim0806 one way of doing this

[terry10 · Accepted solution]

Here's a really easy way to get the desired output.