Merging duplicate values

[RemiC96]

Hi!

I'm working on a data set where I need to combine duplicate occurrences of the 'policy number' in one column and sum two other columns to give me a 'total' of the two columns. I then need to keep the other columns in the dataset.

I'm relatively new to PQ but have attempted to group the values in the column containing duplicate values and have gotten stuck from that point.

Any help would be appreciated, thanks! 

[AntrikshSharma]

@RemiC96 Share sample data.