Parsing / Reordering Data for Easy Duplicate Finding?

I have a spreadsheet with tens of thousands of lines. Attached is what I need to do; basically I need to find departments that have duplicate permission "sets". If the raw data I have was formatted differently, it could have been much easier but I'm stuck dealing with what I got. In the attachment you can see what my approach is. If anyone can either tell me how to do that without having to manually copy-paste cells for days on end OR if there's a better way to find the departments with duplicate permission sets, please help!