I have 2 columns in excel eg:

```
Component Size
A1 12
A2 5
A1 6
A3 10
A2 4
```

I need to get the output as:

```
A1 18 (sum of the values for A1)
A2 9
A3 10
```

Can you please suggest a solution without using macro