Using Coalesce to Pivot.

If we want to pivot the data we could run the following command.
DECLARE @DepartmentName VARCHAR(1000)

SELECT @DepartmentName = COALESCE(@DepartmentName,'') + Department_Name + ',' 
FROM Department
WHERE Department_Name = 'Computers'; 

SELECT @DepartmentName AS DepartmentNames

And get the result set with comma separated in a single column.