I have a large spreadsheet that I'm trying to analyze using a pivot table, but I think I need to reformat it to make it "Pivot Table friendly". Could someone take a look at the attachment and tell me where there's any way to do it?

The example includes country names in the columns and product names in the rows. Ultimately, I'd like to use the pivot table to identify which items are most popular in each country. The "End Result" tab is an example of the type of output I'd like to create. (Note: The "Unweighted" column is important because it tells me whether the data is stable. If the "Unweighted" number is below a threshold then that line item can't be included in the ranking.)

Pivot Table Example.xls

Thanks