Transpose rows to single column

Question

I am using SQLServer. I have a query which gives the following result.

1 Apple
1 Banana
1 Orange

Is there anyway in SQL to traspose it to the following:

1 Apple Banana Orange

Answer 1

SELECT id, names = STUFF((SELECT ' ' + name
    FROM dbo.[table] WHERE id = t.id
    FOR XML PATH(''), 
        TYPE).value(N'./text()[1]', N'nvarchar(max)'), 1, 1, '')
FROM dbo.[table] AS t
-- WHERE id = 1
GROUP BY id;