Summarising data into one row

Hi

Hopefully someone can help with this one.

I have a list of inspection data that details unit name, date and result. This is run over a designated time period and the output displays all inspections that fall within that time period, row by row (sheet 1)

I would like the data summarised to be able to see the last three inspections by unit number, as a summary on one row. (sheet 2)

Any ideas on what formula i need to accomplish this?

Many thanks
Tim.