Most frequent items bought together

Hi All,

I have a database of sales transactions and products bought within those transactions. A transaction could contain between 1 and 20 products. I am trying to find out what the most frequently bought items are, and groups of items.

This kind of analysis is called market basket analysis and I am trying to reconstruct this in excel.

I have attached a sample spreadsheet of the database and what I would like the output to be. The database could contain around 10,000 products within 2,000 transactions so would need a macro to be most efficient.

Hope someone can assist.

Many thanks

Mike