Quick suggestion
😎

DECLARE @test-2 TABLE (
LocationName varchar(255),
Activecases int,
LastSeen DATETIME,
Refresh_date DATETIME
);

INSERT INTO @test-2 (LocationName, Activecases, LastSeen, Refresh_date )
VALUES ('Alston', 3 , '2017-09-09 20:04:01.570', '2017-09-09 20:04:01.570') ,
('Keswick', 2 , '2018-01-02 08:33:18.320', '2017-09-09 20:04:01.570') ,
('Penrith', 5 , '2018-01-02 09:06:43.850', '2017-09-09 20:04:01.570')

SELECT
(
  SELECT
   CONCAT(T.LocationName,CHAR(32),T.Activecases,CHAR(32),T.LastSeen,CHAR(32),T.Refresh_date) + CHAR(32)
  FROM @test-2 T
  FOR XML PATH(''), TYPE).value('(./text())[1]','NVARCHAR(MAX)') AS ALL_IN_ONE

Output
Alston 3 Sep 9 2017 8:04PM Sep 9 2017 8:04PM Keswick 2 Jan 2 2018 8:33AM Sep 9 2017 8:04PM Penrith 5 Jan 2 2018 9:06AM Sep 9 2017 8:04PM

You can use the CONVERT function to get the dates into the desired format 😉