Is there any way that I can transfer my old Apple ID to new Apple ID with all my data?

To transfer the data you need access to the account which then negates the whole reason for setting up a second account, if you get my reasoning. Therefore the best thing is to get the old account working again. Note that an email address isn't tied to a specific device. I can use my email account on any computer in the world.

This article tells you the various ways you can try to discover your forgotten Apple ID --> If you forgot your Apple ID - Apple Support Typically an Apple ID is an email address you have used. If you are currently using a mobile device that is logged into your account, go to Settings and tap your name at the top. Look in Keychain, and in a browser's security settings if you use it to automatically sign into Apple when using a browser.

This article outlines what to do If you forgot your Apple ID password --> If you forgot your Apple ID password - Apple Support

or go directly to this link --> http://iforgot.apple.com/

If you find you can’t sign in, reset your password, or receive verification codes, you can request account recovery (read this support article: How to use account recovery when you can’t reset your Apple ID password - Apple Support ) to regain access to your account. Account recovery might take a few days or longer, depending on the specific account information you can provide to verify your identity.

If you still need help:

Contact Apple for help with Apple ID account security "This article provides country-specific Apple Support contact information for customers seeking help with their Apple ID password or other security-related issues." Click here --> Contact Apple for support and service - Apple Support

If you can still sign into your account on another device you can investigate adding more ways to get a code such as multiple telephone numbers where you can receive a text or a phone call. This is from the section "About trusted phone numbers and trusted devices" in the article: Two-factor authentication for Apple ID - Apple Support

To see, add, or change your trusted phone numbers use one of these methods:

● On your iPhone, iPad, or iPod touch: Go to Settings > your name > Password & Security. Next to Trusted Phone Number, tap Edit.

● On a Mac computer choose Apple menu  > System Settings (or System Preferences), then click your name (or Apple ID). Click Password & Security, then add or remove a trusted phone number.

● Using a web browser: Go to the Account Security section of https://appleid.apple.com .

Similar information for the iPhone can be found here --> Use two-factor authentication for your Apple ID on iPhone - Apple Support

If you had set up an Account Recovery Contact ( Set up an account recovery contact - Apple Support ) you can also get a code that way.

If you can’t sign in, access a trusted device, reset your password, or receive verification codes, you can request account recovery to regain access to your account. This article explains how to recover your Apple ID after a waiting period - How to use account recovery when you can’t reset your Apple ID password - Apple Support

You may also wish to read the articles 'Two-factor authentication for Apple ID' ( Two-factor authentication for Apple ID - Apple Support ) and 'Get a verification code and sign in with two-factor authentication' ( Get a verification code and sign in with two-factor authentication - Apple Support ). Various sections contain information that is useful in understanding about the trusted devices (an iPhone, iPad, or Mac that Apple knows is yours) system, and how to get a verification code on a trusted device or at a telephone number.