Auto populating columns

Deleted 

Hi Jdelong,

First of all: smart move to consolidate the data into a single environment.

You have several options:
a. Use the OOTB "Open with Explorer" (using IE) or the SharePoint Online Modern view to upload complete folder structures.
You end up with new creation/modification dates and the metadata can only be extracted from Office files.

b. Use the Microsoft Migration tool (https://docs.microsoft.com/en-us/sharepointmigration/introducing-the-sharepoint-migration-tool)
This is a free tool. The metadata extraction is again very limited.

c. Use Enterprise migration tools (see https://directory.collab365.community/office365-sharepoint/best-sharepoint-migration-tools/)
These tools provide rich functionality to retain original modify dates or permissions. The ability to extract metadata from the document's various between the tools.

d. Use 3rd party apps that provide metadata extraction capabilities (e.g. http://www.slimapplications.com/product/explorer/)
The apps provide functionality to extract metadata from various types (Office, emails, PDFs, images, audio files, video files, ...) during uploading.
e. Use ODFB sync client
Though it allows uploading of files it does not support metadata. 

Paul | SLIM Applications