How to fix compilation imported as many albums & tracks?

I fixed this manually once but have just had it happen again and hoping there is a simpler way. I imported a compilation of ~75 songs, with ‘Use as is’ and it’s landed as ~30 different albums with 1/2/3 songs each.

Some with albumartist ‘various’ and some actual artist names.

Is there an easy way to fix this mess I’ve made?

How should I import these ongoing? using [G]roup albums, or search and replace with a text editor at import?