Explaination of Data:

I have 2 Columns in the "RawData" sheet in the file attached. One says the Shipment Number, and the other says the Product Code. One shipment, will always never have duplicate product codes.

I want to organize the data in the following fashion (as seen in the "Format" Sheet). I wish to acquire the trends of grouping of products, meaning what product (by product code) is sold together, to understand the hottest combinations.

Can someone help me suggest the best way to do this? Thank you for your help.

Book1.xlsx