We see an issue in the workspace reports, due to misspelling at website the same record added multiple times. something like below, I need to update second row value which is "sample reQuest" to the "sample request" to get the actual count.
sample request | 5 |
sample reQuest | 4 |
What is the best way to update the second record value. is there any way to sum of both without updating the record?