I want to find duplicates in Column A & Column K and combine rows from D to J. Currently, I am using Kutools to combine rows. I want to use VBA to summarize the data.
Input
Desired Output
Sub HSNTotal()
Dim Cl As Range, Rng As Range
Dim Txt As String
With...