How to sum the values of a column based on value in another column

[AMIT_GULATI]

Hi, I have a column named project name and another column named allocation %

I want to sum up the allocations for each project. Currently there are multiple rows for each project with different allocation %.

How do i do that and show only one row per project?