Managing Tables by Exceptions (differences in naming conventions)

Hi everyone, I'm willing to bet many of us have run into this before. I am working on building a cross functional report that looks across HR, Finance, Sales, Marketing, etc... The problem is, all of...