Thanks for the query - I will try to disect it and see how it works.

Speed wise is pretty slow - 55 minutes to run on 137,000 rows

But it gives...

Hi this is not quite what I was after. Basically I am after something like this:

Say here is my input data

Name ...