I’m not sure how well this will work for Compilation albums with multiple artists - that might throw things into chaos - though potentially you could reverse the selection of Artist & Album so you’re grouping my album name first.
Been looking for an excuse to play with pivot tables for a while. For years I’d heard the term but wasn’t sure what they were. By the time I found out what they were I no longer had the problem they’d have solved for me. ho-humm. Funny old world.
Using the basic duplicate finding formula: *IF(B2)=(B1),“Duplicate”,"Keep "
Where B is the column contains the album titles, and pull down the formula to the remaining table. and for obvious reasons this does not work for Compilations.
My test sample sorted well, though admittedly, I’m still learning about formulas and I got lost on the merge data step.