Dear all,
I have a sheet with 3 columns as following:
Products, branch, amount
a branch has many products
so i want to groupby the products for each branch
then count each product for each branch
then do the sum of amount for each product in each branch
for example:
products nb-of-products sum-of-amount
ice cream 5 27
Chocolate 14 38
Juice 7 12
This table will be copied in a new sheet for each branch
any ideas please?
Thank you
Bookmarks