怎么将数据竖的变成横，多谢

如何将数据竖的变成横，谢谢
jl_carnamesl
a宾馆2
b1号招待所1
b宾馆1

变成
jl_car宾馆1号招待所  
a 2 0
b 1 1



[解决办法]

SQL code

TRANSFORM Sum(sl) AS f3OfSumSELECT jl_carFROM Table1GROUP BY jl_carPIVOT name;