SQL Server change column format to rows -

my db records in column format:

ingredient    product ing1            aaa ing1            bbb ing2            aaa ing2            bbb ...             ... 

i see data in format:

product    ingredient1      ingredient2 aaa           ing1              ing2 bbb           ing1              ing2 

select * (   select product, ingredient   db  ) d pivot (   max(ingredient)   ingredient in ( ingredient1 , ingredient2) ) piv 

but query return empty ingredient1 , ingredient2.

i suggest use type of query:

select     product,     max(case when ingredient = 'ing1' ingredient end) ingredient1,     max(case when ingredient = 'ing2' ingredient end) ingredient2      db group     product;