But you could try to sort by the column with the content ALBUM.
Then you should see where the ALBUMARTIST is different.
If you align* the column for ALBUMARTIST near to ALBUM, it should be easy to spot different ALBUMARTISTs
** you can drag & drop every column to whatever position is best for your task.
Perhaps the approach to check the path and the ALBUMARTIST is a little easier: "$ifgreater($strstr($lower(%_folderpath%),$lower(%albumartist%)),0,1,0)" IS "0"
This script finds songs in the same album that have different album artists and puts their info (including the file path) into an Excel file. Then you can see which songs need fixing and use mp3tag to change their tags.
If you want to go this route, I would suggest to create a *.m3u playlist with the same filepath (not an Excel sheet).
This way you can load this *.m3u directly into Mp3tag and manipulate your tracks accordingly.
This tool can scan your music library and identify discrepancies in album artist information within the same album. It processes various audio file formats, extracts their metadata, and generates a .m3u playlist file containing the file paths of songs with such inconsistencies.