help with filling in grid based on raw data

[harleyberger]

I want to fill in data in this grid based on a data sheet that includes raw data.

Here's the grid....

SS-20120417131538.jpg

Here's the data sheet...

SS-20120417131548.jpg

For each cell in the grid, it will need to match based on the 'week ending' field and the 'sponsor' field. And I only want to list the product once in each cell in the grid regardless of the number of times that it's listed in the data sheet - for example, for week ending 3/11/12 Arby's Product1 is listed twice in the data sheet, but I only want it listed once in the grid.

Is there a formula that I could use in each cell in the grid that would produce this result?