Hello -- if you look at the "Sample Excel Data" which comes with the Excel data mining add-in, there is a table in there which shows the layout. There would be one record per product, and then you could have multiple records per supplier.
Or you could be saying that the transactions have multiple combinations of products and suppliers. In that case, you can perform the analysis either on the supplier or the product. Since the product names are same across suppliers, I would concatenate
product and supplier together into a single field.
Mark Tabladillo PhD (MVP, SAS Expert; MCT, MCITP, MCAD .NET) http://www.marktab.net
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.