This way
DECLARE @MyTable TABLE (TableNumber INT, [Text] VARCHAR(1), OrderArranged INT)
INSERT INTO @MyTable
SELECT 1, 'A', 1
UNION ALL
SELECT 1, 'B', 3
UNION ALL
SELECT 1, 'C', 2
SELECT [TableNumber],[Text] = STUFF((
SELECT ' ,' + [Text] FROM @MyTable
WHERE TableNumber = x.TableNumber
ORDER BY OrderArranged ASC
FOR XML PATH(''), TYPE).value('.[1]', 'nvarchar(max)'), 1, 2, '')
FROM @MyTable AS x
GROUP BY TableNumber