Help with summarising table

[nikola2004mkd]

Hello. I have a large table in a following format. Note that code despite beening a number is stored as text.

Code Material Quantity used
1 wood 5
1 wood 8
2 metal 4
2 metal 4

How can I re-arange it in following format

Code Material Quantity used
1 wood 13
2 metal 8

Thank you.

[Kamal1234]

Hi, please attach your workbook or a screenshot so I can have a quick glance on the way you've structured your tables.

Regards,

Kamal

[nikola2004mkd]

Here you go.
Capture.JPG

[63falcondude]

Assuming that the data in the top table is in A3:C6, try these formulas:

A10 =IFERROR(INDEX(A$3:A$6,MATCH(0,COUNTIF(A$9:A9,A$3:A$6),0)),"") Ctrl Shift Enter
B10 =INDEX(B$3:B$6,MATCH(A10,A$3:A$6,0))
C10 =SUMIF(A$3:A$6,A10,C$3:C$6)

See attachment

[nikola2004mkd]

Any drag-n-drop solution?

[AliGW]

What do you mean by 'drag-n-drop'?