Hi,

Thank you for the reply. Looks like it'll do the trick. I agree the data isn't in an ideal format. But i'll have to make the best of a bad...

There will only ever be two of the same ID number due to the nature of the data.