• Hi All, Thanks for the advice. Got it sorted using a PIVOT and cross apply combination. 

    Regards