Thank you for your quick responses!

ARGK - Unfortunately a pivot wasn't quite what I was after, as I may need to add in comments, or formatting afterwards, and need the layout not to change at all (so engineers names and dates are always in the same positions.

benishiryo - Your array formula works perfectly and does just what I need it to!

Thanks again - much appreciated.