show most recent data for multiple rows

Hi

I have searched for a solution to my issue without luck, which should have a simple solution. I would like to create a table to show most recent data for multiple rows. An example of my data set:

I can filter my data by week number to the above, but I would like to display the most recent entry for each ID. ‘Distance’ increases throughout the week, however ‘guide’ does not, hence filtering by max doesn’t work.

the outcome table I would like to create is:

Thanks in advance for your solution/s.