Hi Sandy666
Apologies for the delay - been struggling on how to add attachment.
It's pretty obvious that as a relative newby to Excel I'm not making myself very clear. On Sheet 2 of the attached file I would only have expected "RADIATOR" to be included in the "Fault" column twice as it is the only repeated item together with the supporting duplicate row data e.g. A1:E:1. Sheet 3 shows the expected result. Hopefully, this will help - thanks again.
Bookmarks