create table ProductSales(Salesperson varchar(50),Product varchar(50),SalesAmount money)
insert into ProductSales(Salesperson,Product,SalesAmount)values
('JOHN','SOAP',200),('PETER','SOAP',500),('JAMES','DETERGENT',100),('ROGER','DETERGENT',200)
SELECT SalesPerson, [SOAP] , DETERGENT
FROM (SELECT SalesPerson, Product, SalesAmount FROM ProductSales ) ps
PIVOT
(
SUM (SalesAmount)
FOR Product IN
([SOAP], DETERGENT)) AS pvt
