Hello,
There is no direct way to do the consolidation, you will have to migrate the data from one tenant to another tenant.
In my experience, I use third-party tools to do this task, such as AvePoint Fly.
In the same way, I share with you the official Microsoft documentation that talks about this.
I hope this helps!
Remember to accept the answer if it is helpful.