Deduplicate Records

I have a mySQL table that will have duplicate records show up occasionally. Is there an easy way to merge these records according to a specific criteria (some duplicates are actually desired in certain columns but not in others) so a chart report won't show the duplicates?

Thanks!