Thanks Very much Bebo, this does work and is definitely on the lines of what I am aiming for, however some of the results are not quite as expected:

My apologies. Where I have TEST SITE 1 this needs to be in the same cell for example, Newcastle Road

Also, I didn't want to put all of the column headers in my initial posting, but there are roughly the same amount of column headers again. Would I be able to amend your formulae for use with the additional column headers easy enough?


Many thanks for all your help

David