Merging duplicate values and totalling the data from within those rows

[TravelMI]

Hi,

I have a spreadsheet with just three columns but after using the Conditional Formatting to highlight duplicate values from column A (Name) there are duplicates present as per the first table below. I need to get to a stage as per the second example whereby the duplicate Names have been merged together and the data on each of their rows are summed up.

Is there a formula I can use that will allow me to do this? There would only ever be two duplicate Names if that helps at all.

I look forward to receiving any responses.



[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number of Transactions[/TD]
[TD]Spend[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2[/TD]
[TD]£10[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]3[/TD]
[TD]£15[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]4[/TD]
[TD]£25[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]5[/TD]
[TD]£20[/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Number of Transactions[/TD]
[TD]Spend[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]7[/TD]
[TD]£30[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]3[/TD]
[TD]£15[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]4[/TD]
[TD]£25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]