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 |
