Can you provide readily consumable DDL and sample data? It's confusing with what you have provided. Is the employee ID in the TimeKeeper, Alt1Timekeeper or Alt2TTimekeeper columns? You may have to unpivot the organization table first, but unclear with what is provided. Also, your data example has 5 columns for the last 2 rows in Organization