Find most recent & 2nd most recent date of a col. for a specific value in another co

Hello,

I have an issue here that I can not solve by myself of by using Google...
To explain :
I have an extraction of a DB in an excel file with 3 columns : Device number, Meter reading Date, Meter reading value
In that file, there are several entries for each device as you can see in the screenshot below or in excel file.
My aim is to report in another sheet, for each device :

- the most recent date & corresponding Meter reading
- the second last date & corresponding Meter reading.

After that I have to do some other stuff, but it's easier

Could you help me to find a solution for this ?

Thank you

Example_consumption.xlsx_Excel.jpg

Example consumption.xlsx