用union啊类似于下面

select '1月' 月份,1月 产量, 产线

union

select '2月'' 月份,2月 产量,产线

CREATE TABLE dbo.Venders 

(

    VendorID int, 

    Emp1 int, 

    Emp2 int,  

    Emp3 int, 

    Emp4 int, 

    Emp5 int

);  

GO 

INSERT INTO dbo.Venders VALUES (1,4,3,5,4,4);  

INSERT INTO dbo.Venders VALUES (2,4,1,5,5,5);  

INSERT INTO dbo.Venders VALUES (3,4,3,5,4,4);  

INSERT INTO dbo.Venders VALUES (4,4,2,5,5,4);  

INSERT INTO dbo.Venders VALUES (5,5,1,5,5,5);  

GO

SELECT VendorID, Employee, Orders  

FROM dbo.Venders as p 

UNPIVOT  

(Orders FOR Employee IN   

      (Emp1, Emp2, Emp3, Emp4, Emp5)  

)AS unpvt;  

GO

示例

--------

列转行直接用UINON 链接 最简单