如何将行数据转换为列数据？

WITH FieldValueCte AS(      
SELECT  Name,
        \'Department\' Field,
        Department Value
FROM    Table1  UNION ALL
SELECT  Name,
        \'Sex\' Field,
        Sex Value
FROM    Table1  UNION ALL
SELECT  Name,
        \'HireDate\' Field,
        HireDate Value
FROM    Table1  UNION ALL
SELECT  Name,
        \'Salary\' Field,
        Salary Value
FROM    Table1  UNION ALL
SELECT  Name,
        \'Comments\' Field,
        Comments Value
FROM    Table1)

SELECT [Field], [John Doe], [Jane Smith], [Peter Parker], [Jessica James]
FROM
(SELECT Field, Name, Value
    FROM FieldValueCte) AS SourceTable
PIVOT
(
MIN(Value)
FOR Name IN ([John Doe], [Jane Smith], [Peter Parker], [Jessica James])
) AS PivotTable;