I have been cleaning up my data the last few days as well and had as many as 3 dozen of any one census sources! As far as I could tell, the differences were primarily due to time and typing. For example, a space was missing in one that was in the others, Ancestry had been replaced with The Generations Network for others. Some were longer and some were shorter but they all had essentially the same information.
I replaced as many as I could but it was pretty tedious and could be so much easier. Also indicates that it may be clean for a short time but will get muddied again as you add more records/events/people.
In the same way, I was Resolving my Places and found that when I was in Resolve All and checked the Desc column it does not move only the unrecognized text to the description field - it moved the whole place name to description. I wish that had been clearer. FYI.