Good morning everyone,

I'm making my internship in a company, and have a lot of work with excel. I'm ''beginner'' so struggling some times.
What I need to do is :

A B C
1 Company Group Quantity
2 ABC 2 30
3 DEF 1 20
4 GHI 2 25


This is the main table, where you enter all the values (company name, group of consumption, and quantity of consumption).

E F
1 (Group) 1 (Group) 2
2 20 30
3 25


This is how the second table should look like. If I enter infos in the first table, I need that it appears automatically in the second one.

Sorry for my English, hopefully I was clear. Thank you for your help !