Refer the below test query for your Refrance.
DECLARE @MyTable TABLE (TableNumber INT, [Text] VARCHAR(1), OrderArranged INT, TableChapter int)
INSERT INTO @MyTable
SELECT 1, 'A', 1 , 1
UNION ALL
SELECT 1, 'B', 3 , 1
UNION ALL
SELECT 1, 'C', 2 , 1
UNION ALL
SELECT 2, 'f', 1 , 2
UNION ALL
SELECT 2, 'g', 2 , 2
--UNION ALL
--SELECT 2, 'e', 1 , 3
SELECT [TableNumber],[Text] = STUFF( ( SELECT ' ,' + [Text] FROM @MyTable
WHERE TableNumber = x.TableNumber AND TableChapter = x.TableChapter
ORDER BY OrderArranged ASC
FOR XML PATH(''), TYPE).value('.[1]', 'nvarchar(max)'), 1, 2, '') , TableChapter
FROM @MyTable AS x
GROUP BY TableNumber , TableChapter