Thanks for the response Sam, is there a more efficient way to handle this instead of all the manual steps? Or a way to automate a special import to rename the record, inactivate, and create new.
The manual side of this is mind numbing so kudos to everyone that does it.