SELECT country, sector, my_percent 
into sectors_new
FROM [dbo].[sectors] p  
UNPIVOT  
   (my_percent FOR sector IN   
      ([Agriculture_forest]
      ,[Industry]
      ,[Manufacturing]
      ,[Construction]
      ,[Wholesale_and_retail]
      ,[Information]
      ,[Financial]
      ,[Real_estate]
      ,[Science_Technical]
      ,[Public_administration]
      ,[Arts_entertainment])  
)AS unpvt;