I have a daily report of product shipped and multiple product codes.
These codes are then put into product groups.
Example
Product Group Wire Spares Wire Spares Equipment
Product code 3910 3911 3912 3913 3914
Sales by Day
Day 1 10 15 20 5 300
Day 2 5 10 35 50 200
Day 3 20 35 20 0 250
How can I use a function to group and sum to the produce this output
Sales by Day Wire Spares Equipment
Day 1 30 20 300
Day 2 40 60 200
Day 3 40 35 250
See attached file
Thanks