How to consolidate rows with same values in an Excel table?

Question

I am trying to consolidate rows that contain the same values in an Excel table.

I want to consolidate just the Code column that have the same values, so that I get the sum for each Code category 1, 2, 3, like the image below:

How do I implement this in Excel (without using VBA)? I tried the consolidating feature in Excel but it did not work. Thanks in advance.

Answer 1

You could use subtotals like this...