I had the same requirement and with help from Nicholas from ShareGate Support team, I managed to automate it: I exported SP lists to Excel, made transformations and imported them, all with one press of a button =)
In case someone is interested: https://dev.to/kkazala/sharepoint-migration-with-sharegate-powershell-4h19 I'm heavily quoting Nicholas
I had the same requirement and with help from Nicholas from ShareGate Support team, I managed to automate it: I exported SP lists to Excel, made transformations and imported them, all with one press of a button =)
In case someone is interested: https://dev.to/kkazala/sharepoint-migration-with-sharegate-powershell-4h19
I'm heavily quoting Nicholas