You are in luck. My company is launching a free solution to exactly this problem. You will be able to normalize tables of data (from csv, txt, xlsx and more) that have the same subject matter but different formats. Variations in names, scalings, enumerations, derivations and more are automatically handled. You won’t need to hand over your data and you can choose to share the process you’ve created with anyone else in the world (or keep it private). Email me at info@liquidaty.com, we would love to help you with this as part of our private beta and I’m certain it will save you a ton of pain (and anyone who comes after you who you'd like to enable to solve this same problem in the future)