Macro to find duplicates, concatenate cells, then delete old duplicates

Hi everyone,

I am very new to VBA, so I'm not even sure if what I'm trying to achieve is possible with a macro. I guess I'm looking for advice on whether it is possible, and if so, how to go about building it.

My issue is that I have a sheet of data that contains duplicate rows. I want to first locate any duplicates, based on a name field, then merge those duplicates into one row. I'll need to concatenate the values in each duplicate's "description" field, and comma separate them. Then I need to add up the total of the duplicates' "value" fields. Then I need to delete the duplicates, and just have that one merged row remaining.

I've attached a sample sheet for reference.

I'm sorry to post the question before trying anything myself, but I've spent hours on these forums trying to find another example that matches my problem, and I just can't find anything that works.

Thanks so much for any input!