Please help in providing macro to concatenate and sum as below table.
Below table starts from A2 to C9 (i'm leaving first row blank to write main header.)
Customer Part Number
Reference Designator
Count
91814232
C339
1
91832745
MN28
1
91832745
MN7
1
91835171
MA2
1
91835171...