try this batch
DECLARE @Ids VARCHAR(200)
DECLARE @Query VARCHAR(MAX)
SELECT @Ids=REPLACE((select DISTINCT Col1 AS 'data()' from YourTable for xml path('')), ' ', ',')
SET @Query = 'SELECT '+ @Ids + ' FROM ( SELECT Col1,Col2 FROM YourTable) AS A'+
' PIVOT (SUM(Col2) FOR Col1 IN ('+ @Ids +')) As PVT'
EXEC(@Query)
Thank you