I have a data set that contains; Employee Status, First Name, Last Name,Reports To, Hire Date
Weekly, I will receive a list of Terminated/New Hires and Transferred Employees in the same exact Format.
I would like to add new rows for new employees and I'd like to fill in a date in a new column for terminations and transfers.
Ultimately, the Data will look like;
Employee Status, First Name, Last Name,Reports To, Hire Date,Termination Date, Transfer Date
Thanks for any ideas/suggestions.