Tag to Tag Exchange

I have a folder in which there are several MP3 Music files. I want to interchange the data in the Field "Album artist" with the data in the Field "Album" in one go for all the files. Please provide me step by step instructions how to go about it.

See this post in the FAQs:

I did the following steps but the swap did not happen. Please correct me where I am going wrong.

Open Mp3tag:
    Launch Mp3tag on your computer.

Set the Directory:
    Click on "File" in the menu and select "Change directory..." or press Ctrl+O.
    Choose the folder containing your MP3 files.

Select All Files:
    Press Ctrl+A to select all files in the folder.

Create Custom Actions:
    Click on "Actions" in the menu and select "Actions" or press Alt+6.
    Click on the "New" button to create a new action group.
    Name the new group, e.g., "Swap Album and Album Artist."

Create Action to Swap Tags:
    With the new action group selected, click on the "New" button to create a new action.
    Choose "Format value" as the action type.
    Set the field to %temp%.
    Set the format string to %albumartist%.
    Click "OK" to create the action.

This action will store the data from the "Album Artist" tag in a temporary variable.
    Create another action:
        Choose "Format value" as the action type.
        Set the field to %albumartist%.
        Set the format string to %album%.
        Click "OK" to create the action.

This action will copy the original data from the "Album" tag to the "Album Artist" tag.
    Create a third action:
        Choose "Format value" as the action type.
        Set the field to %album%.
        Set the format string to %temp%.
        Click "OK" to create the action.

This action will copy the data stored in the temporary variable (original "Album Artist" data) to the "Album" tag.

Apply Custom Action:
    With all your files still selected, go back to the "Actions" menu, select your new action group ("Swap Album and Album Artist"), and click "OK."

Save Changes:
    Click the "Save" icon (or press Ctrl+S) to apply the changes to all selected files.

If you have a close look at the linked action, you can do it in 1 step with a single action and no requirement to use auxiliary fields like TEMP.

All further help would be much easier with real data from a real file wih a statement which data could be found at the start and what the outcome of the manipulation should be.

I tried doing what you have recommended but it is still not helping. Enclosing the picture of the music folder.

Replace your steps #5 to #8 with


as mentioned from @ohrenkino above.

Replace
%title%~%artist%
in the above example with your
Source format: %albumartist%~%album%
and your
Guessing pattern: %album%~%albumartist%

Thanks, problem solved. I had made a typo while entering.

One more help I require, How can I convert the data in my MP3 Tag folder into an excel file?

You can use the Export function:

Please create a new topic for your new question(s) if you need support to create a CSV file which you can import in Excel.