I am stuck trying to make an overview of customer orders in the database in Excel,
It concerns around +/- 100 customers in the list, with about 1000 orders, with several columns of the products with the number of the order next to it.
I want to create a summary of the total of every product that was ordered, every single product in quantity and (if possible) also a sum of the countries that order a specific product. (see beneath for an overview of what I mean, only more columns are in the actual sheet)
I have googled a bit, but I couldn’t find anything, so I hope someone here can help me out.
Thank you in advance!