I need to evaluate shipment orders that allocate promotional item sales across shipment sites. Since multiple promotions will be analyzed (2 are provided in attached), a pivot table filtered by promotion seems most logical (and quickest). I need my table to list “Shipment Site”, “Sales”, and “Promotion Applied”. However, the site and sales data I need span multiple columns since multiple sites can be used to complete an order (i.e. an order of 5 may pull 2 items from one site, 3 from another). Our software’s output (yellow highlighted column in attached) lists sites and sales joined by a colon. I separated these into new columns (data > text to column) (I did not look into trying to change text to rows since I would have to copy the remaining data down each time and there are thousands of records). I can’t figure out how to best consolidate my shipment site and sales data info. Since I’ve been playing with this for some time now, any help or insight would be absolutely super!!
((disclaimer: data presented not actual data))
Bookmarks