Transposing relevant data between sheets

[Gavalar]

I've taken part of our instrument service data and eventually want to trend the performance but have decided it will only useful to use data where I have 4 or more data points. However with so much data I want to automate the process rather than scrolling through the column. I assume this requires a lookup table of sorts but I don't know how to combine that and getting the other bits of relevant information (I.e. all dates and results).

Any help much appreciated and I'll keep trying myself in the meantime.

Regards

GavInstrument Spec data.xlsx

[Kaper]

As a starting point you could use Pivot Table to select only interesting serial numbers (4 occurences or more). See attachment.