It sounds like you want to concatenate the rows into a single cell. To do that do
DECLARE @RowsIntoCell NVARCHAR (MAX);
SELECT @RowsIntoCell = COALESCE(@RowsIntoCell+ ',', '') + ColumnThatHasValues
FROM YourTable
This will take all values from a column (ColumnThatHasValues) and comma delimit them into a variable named @RowsIntoCell