Merging Rows on a Unique Identifier while Keeping Unique Data and Adding Values Together

Hello. I have a large excel spreadsheet where I need to merge rows on a unique identifier. However, I don't know the best way to tackle this as I'm not very proficient in Excel VBA yet.

Here is a picture of an example of what I'm trying to do. The data including the headers in the picture are all made up for the example but what is demonstrated is exactly what I'm trying to do.

Stack Overflow Example Picture for Question.png

I would appreciate any help or tips anyone can give me. Thank you!