Get Duplicate Data in Generate Data Table

[jamuri]

Hi,

I would like to know how can I search match data in my case
first few number/character is the same but sub sequence char is different ( e.g data 1 = 1234 and data 2 = 1234A) and add the amount from both data.

Screen capture as below

Thank you
Regards
Jamuri

[jamuri]