This works also from the article you attached... again, Thanks!

SELECT SalesPerson, COALESCE([Oranges],0) AS Oranges,

COALESCE([Pickles],0) AS Pickles,

COALESCE([Bananas],0) AS Bananas,

COALESCE([Apples],0) AS Apples,

COALESCE([Grapes],0) AS Grapes,

COALESCE([Melons],0) AS Melons,

COALESCE([Beans],0) AS Beans

FROM

(SELECT SalesPerson, Product, SalesAmount

FROM names) ps

PIVOT (SUM(SalesAmount)

FOR Product IN ([Oranges], [Pickles], [Bananas], [Apples], [Grapes], [Melons], [Beans])

) AS pvt

SALESPERSON ORANGES PICKLES BANANAS APPLES GRAPES MELONS BEANS

Bob 330 280 400 250 0 200 125

Ed 160 240 80 175 175 185 320

Jim 130 160 370 185 160 0 0

Sid 185 160 0 75 130 370 140

Sue 0 310 820 780 315 220 185