how to display string into single column in sql

SQL Server STRING_AGG() Function is string function which concatenates values for any given string expressions and separate them a specified separator.

It does not add the separator at the end of the result string.

String expression values are implicitly converted to string types and then concatenated.