Basically, I have spent half the day trying to work out if this is possible, to create a formula to take all the tidy up the titles under one location, I have tried a variety of Match and Index functions, Tried Lookups, only just started getting to grips with the CTRL+SHIFT+ENTER array formula but seem to only get the same result in every cell, not sure if that is right.

anyway I have lost all hope right now, hence why I am on here hoping for some help. please find below a link of what I would like,

https://www.dropbox.com/s/e7feu2fvjz...Help.xlsx?dl=0



Thanks in advance for any help given.

Kind Regards

Steve