How to select latest record

Hi,

i have the following sample data

I am trying to explore doing the following

1) create a latest_contact field such that the output is as follows

I ran out of ideas how this can be done and so need to advice of experts here

Thanks in advance