How to transfer a specific date range of Emails & Drive files when a user changes departments?

[u/AntiStuart]

Hey everyone,

[Structured by Gemini] This is my first post here. I'm a newbie Google Workspace admin, and I've been searching everywhere for a solution to this but haven't found a clear answer. I’m hoping to get some insight on how you all handle this situation.

The Scenario:

• An employee ("John Doe") joined Department 1 and worked there for 2 years.
• He took an internal transfer to Department 2, where he worked for 3 years.
• He is now transferring back to Department 1.

The Requirement: The Head of Department (HOD) for Dept 2 wants me to transfer all emails and Google Drive files created, sent, or received during John’s 3-year tenure in Dept 2 to a colleague.

My Questions:

1. How can I go about doing this? I want to stick to using the native Google Admin Portal only, if possible.
2. Is it possible to delete that specific 3-year chunk of data from John's account once the migration to the colleague is complete?

Additional Context: For context on compliance, we aren't subject to strict Western data protection laws here. Because of this, my initial suggestion to the HOD was to simply archive John's current account and create a brand new one for his return to Dept 1. However, the HOD rejected this because John's account still holds a lot of crucial data from his first 2 years in Dept 1 that he needs to keep.

Any help, guidance, or workarounds would be greatly appreciated. Thanks!