Fuzzy Match Condense multiple rows

[monish_chandra]

I'm trying to condense multiple rows into a single row based on fuzzy match threshold as 80%. eg: If there are multiple lines with a match threshold of 80%. Then I want to condense the rows into a single row and add the $ amount for each row. 

Material Number	Reseller	Total
TUUKSBNGM	GOVERNMENT ACQUISITIONS	34765
TUUKSBNGM	GOVERNMENT ACQUISITIONS, INC.	6875
TUUKSBNGM	GOVERNMENT AQUISITIONS, I	183783

Expected Output

Material Number	Reseller	Total
TUUKSBNGM	GOVERNMENT ACQUISITIONS	225423

[ArtApa]

Hi @monish_chandra - Here is a possible solution: