Finding multiples of unique values

[vbfbryce]

Could you mock up a small example of what the data looks like (I think I'm clear on that part), and what you want the "output" to be (not so clear on that)?

[sh1870]

Fruit Country Unique Fruit Spain Greece Italy France Chile Australia
Orange Spain Orange 1 0 0 0 0 0
Orange Spain Grape 0 0 0 1 0 1
Orange Spain
Orange Greece
Orange Italy
Grape France
Grape France
Grape Chile
Grape Australia
Grape Australia

OK, suppose I'm buying fruit and have different suppliers in different countries. I want to know when I have multiple suppliers from one country, indicated by a 1, and when that isn't an issue; 0.