select IngredientName ,Carbohydrates,Isoleucine , Alanine from(select IngredientName ,NUTRIENTNAME ,NValue from table1) up PIVOT (sum(Nvalue) for NUTRIENTNAME in(Carbohydrates,Isoleucine,Alanine)) as Pvt
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)