I am having trouble finding the correct function to combine data on a spreadsheet I'm working on (attached). Essentially, I have data in column A with names, many of which occur several times throughout the column. However, each row has a specific numerical value in column B. I am trying to consolidate the data by combining rows with similar names but summing the numerical values. For example:
If someone could help me out with the function and how to complete it, that would be greatly appreciated.