keeping most recent data in column
I want to keep the most recent data and delete the older data.See image below I want to keep most recent data for highlighted machines and and delete the older row.example machine 12 I want to delete 2019 data and keep the 2020 data.