Hey,
I have a warehouse of 7000 different products. Each with a unique 8 digit number.
I have thousands of orders each day each with a unique order number for each order.
I am attempting to find out which products are most commonly picked together so that I can physically put them closer together.
Because at the moment the products just go all over the place.
I have tried using pivot tables but for the sheer amount of data I have this is just not usable.
Can anyone help?
Bookmarks