It is possible, but not sure how big your real data is, but just give it a try
1st, you need join your data to itself as shown below using a key 1=1
2nd, after join, you will have two produce fields, and drag one to column and the other to rows.
3rd, create a calcuation field to count the common component
A sample workbook attached for your reference as well.
Hope this helps
Book1_v10.2.twbx 9.0 KB
Thank you for your response.
I was hoping to find a different solution as this creates too many data entries. from the 10 rows in the original data set it has increased that to 100 rows.
With my data set I have many products, I am creating a dashboard with just a sample of 45 products at the moment. But with just 45 products this method generates over 1 million rows, this will not be a viable solution for my full data set. I was hoping for a solution that did not generate any more rows.