Basically has 3 versions of this for each of the desired columns ( ActiveCases, Last seen, & Refresh) 
SELECT   *
FROM    (SELECT   LocationName, ActiveCases
         FROM    [FairWarning_Extract].[dbo].[vw_Adastra_Live]) AS s...

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

Regards

Hi, thanks for the reply but i need to get them into separate columns rather than a single sting ????

Apologies if my example gave the wrong impression.