Wow that was fast and Sorry having to use my cell as site is blocked on work pc so made the ask to brief. In the end I would like the following result. Keeping the data set as is with a new variable or ‘Original RM’ being added. Date ACCOUNT RM Original RM 1-1-18 123 Gabe Gabe 1-2-18. 123 Gabe Gabe 1-3-18 123 Mary Gabe 1-1-18 234 Bob Bob 1-2-18 234 Bob Bob 1-3-18 234 Bob Bob 1-1-18 789 Sam Sam 1-2-18 789 Mike Sam 1-3-18 789 Betty Sam I would be using this report to capture who added the account originaly not who manages the acccount today.
... View more