Today I had to analyze and cleanse some data to migrate to a new system we are developing. The data is coming from an existing access database…