report that will reflect the date the STATUS was changed from one STATUS to another

[lirans]

Hi,
I am getting every day new data with the columns: IDNUMBER, STATUS ( A, B, C), and DATE (the date of today) ( around 5,000 rows each day)
I need a daily report that will reflect for each ID NUMBER the date the Status was changed from A to B and from B to C.
I think it will be best explained in the attached file.
I can use Excel formulas and Power query.
I have EXCEL 2016.
Thank you!

[Estevaoba]

Try in J16:

Please Login or Register  to view this content.

That's an array formula. Paste it and confirm with Ctrl+Shift+Enter, instead of just Enter.

Good luck!