Group Like Items Together

[shobhitdixit]

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

[ragulduy]

Ended up making a mess of variable names (and probably the structure) but I think it works...

Please Login or Register  to view this content.

[shobhitdixit]

Hi,

Thank you for your response. I think I didn't make it clear, and I'd like to sincerely apologise for the mistake.

The idea is to see which product sells more with a particular product. Keeping in that spirit, I think you are almost there, but there is a change I'd like to request.

As you can see in the attached file, I'd like to know how many times a particular product (by product code) was sold with the other. As you can imagine, I have about 300 shipments, but have about 1500 different product codes to deal with, this activity will save me hours of time.

Thank you once again for so much help, and time you have given. I sincerely appreciate it.

[ragulduy]

Again, apologies for the mess but I think it does the job:

Please Login or Register  to view this content.

[shobhitdixit]

I'm sorry but I get a type mismatch error. Also, the "Number of Times" column appears in the RawData sheet.

[ragulduy]

Try:

Please Login or Register  to view this content.

[shobhitdixit]

I get a type mismatch error. But yes, the "Number of Times" column appearing in RawData sheet has stopped.

[shobhitdixit]

I've uploaded the datafile with which I am working. It also shows the result in sheet3, and has the code. This should ease the process.

Thank you so much for your time.

[shobhitdixit]

Sorry for being pushy, and believe me I usually am not - but I could really use some help to fix this - as I need to figure this out - without doing it manually, which would eat up like an entire day - probably with loads of erros

[shobhitdixit]

Can someone help me with this problem?

[Fotis1991]

Thread closed as Op started a new thread in Commercial Sub Forum.