SELECT [country]
	  ,[Agriculture_forest]
      ,[Industry]
      ,[Manufacturing]
      ,[Construction]
      ,[Wholesale_and_retail]
      ,[Information]
      ,[Financial]
      ,[Real_estate]
      ,[Science_Technical]
      ,[Public_administration]
      ,[Arts_entertainment]
FROM  
sectors_new AS SourceTable  
PIVOT  
(  
  AVG(my_percent)  
  FOR sector IN 
	([Agriculture_forest]
      ,[Industry]
      ,[Manufacturing]
      ,[Construction]
      ,[Wholesale_and_retail]
      ,[Information]
      ,[Financial]
      ,[Real_estate]
      ,[Science_Technical]
      ,[Public_administration]
      ,[Arts_entertainment])  
) AS PivotTable; 