Cross Purchase Help

[cdubs34]

Hello,

I am trying to get at some cross buying behavior from a large data set that I have. Here is a simple, example of the data I have:[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD]Brand A[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]Brand B[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Brand C[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]Brand A[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]Brand D[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]Brand C[/TD]
[/TR]
</tbody>[/TABLE]

And then this is my desired output:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Brand A[/TD]
[TD]Brand B[/TD]
[TD]Brand C[/TD]
[TD]Brand D[/TD]
[/TR]
[TR]
[TD]Brand A[/TD]
[TD][/TD]
[TD][/TD]
[TD]<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}--></style>[TABLE="width: 87"]
<colgroup><col width="87" style="width:65pt"> </colgroup><tbody>[TR]
<!--StartFragment--> [TD="width: 87"]The output I am looking for in this cell for example would be the number of people that buy both Product A and Product C. So in this example it would be 2 because John and Amy bought both these products[/TD]
<!--EndFragment--> [/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Brand B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Brand C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Brand D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

There is a ton of data in my actual worksheet so a formula that would make it easy/efficient to get to the desired output would be great. Thanks very much.