Data Relationship?

Hi Guys

I would like to get a way to find out the relationships between the parts ordered

I have attached a sample data set.

Eventually I would like to get to a stage when I can type in a part number and it will bring up other part numbers that were ordered with that part number. Ideally the top ten rather than having a huge lists of hundreds of parts.

I.e The top selling part number in the list is 11511607, I can easily make a formula to bring back all of the order numbers this was ordered on but I don’t want the order numbers, I want the other part numbers on the order in which this part was ordered.

I am trying to get to which parts are commonly ordered together and thus should be stored close together in the warehouse to speed up the picking processes.

Any help or guidance on how I may going about achieving this would be greatly appreciated.

Thanks

Simon