sum the unique values of col A

[e89024]

Hi

I have the below source of data

ID Name Product 9/1/2020 9/2/2020 9/3/2020 9/4/2020 9/5/2020
C2V Test PRod1 10 20 30 40 50
C1V abcd PRod2 9 8 7 6 5
C2V Testing Prod3 1 2 3 4 5
C3V aaaa prod4 2 3 4 5 6

Need the vba code to sum the unique id values, looking for the output as

ID Name Product 9/1/2020 9/2/2020 9/3/2020 9/4/2020 9/5/2020
C2V 11 22 33 44 55
C1V 9 8 7 6 5
C3V 2 3 4 5 6

Can anyone pls share the code to get the desired result

Thanks
Naveen

[mehmetcik]

Please Login or Register  to view this content.