With this Data Table you have to investigate boxes being shipped from 5 different stores to multiple stores. First you will need to create pivot

With this Data Table you have to investigate boxes being shipped from 5 different stores to multiple stores. First you will need to create pivot tables reflecting the unique shipments in detail. Identify how these 5 stores are packing their inventory. Each line will show Box Numbers and the item it contained inside (Item code/PLU) The Division # is the specific code # for a specific genre of item, for example 291 is mens inner wear one specific division/Category however boxes could contain multiple kinds of items within that division for example if there are two item codes with the same division then there are two different types of mens inner in that box (Socks, boxers). The quantity is the amount of each item is in that box, there are multiple lines for one box as stores are shipping more than one item in a box. To ensure that stores are consolidating items into one box when shipping to stores please analyze if stores instead of consolidating they are separating boxes and shipping multiple boxes to one store during each shipment (Ship date)

For this assignment you will be specifying the total amount of shipments these 5 stores have completed to each store location and in total as a whole store. Analyze how many boxes can be reduced if multiple divisions consolidation are applied. Average quantity that is being shipped in each box for each store and if multiple divisions are in one box, if not multiple divisions also specify if store is not shipping multiple divisions in one box meaning they are separating by division or by item which means they are ineffectively shipping and spending more money by shipping various boxes to same store during same Ship Date. 

If only 1 division how many item codes are in a box. Need Average unit per box for all 5 stores. , Separate data for each store.