Thank you both kapil_kk & Luis Cazares,

I'm sorry I have been unexpectedly offline for a few days so apologies for the late reply.

I managed in the end and it wasn't...

Thank you (again) for your speedy reply.

Using this bit of code:

SELECT DISTINCT [Source Data]

FROM #TempSourceOutput t1

CROSS APPLY ( SELECT...

Thank you!

I will read it straight away.