The code below might help:

CREATE TABLE #Temp

(

[Column A] VARCHAR(10),

[Column B] VARCHAR(5),

[Column C] VARCHAR(10)

)

INSERT INTO #Temp VALUES

('XXXXXXXXXX','64856','Test001'),

('XXXXXXXXXX','64857','Test002')

SELECT [Column A] AS ColumnA

,[Column B] AS ColumnB

,[Column C] AS ColumnC

FROM #Temp

FOR XML PATH ('Row')