I have a following table:
Name Qtr Rev$ Net$
New York 2007Q1 1,000 800
New York 2007Q2 2,000 500
New Jersey 2007Q1 1,200 600
New Jersey 2007Q2 1,500 800

I want to convert them in the below format based on the Name field.
THe date would be pulled from the top table.
2007Q1 2007Q2
Name Rev$ Net$ Rev$ Net$
New Jersey 1,200 600 1,500 800
GA
CA
New York

Does anyone have any idea? I've tried sumproduct function, but it
didn't work. thanks!