That's probably possible -- but as is the case with many things that can be done with regexen but which are outside its core utility, it's apt to be awkward, verbose and perhaps fragile.

Better, perhaps, you may wish to study up on the various CSV modules and the many compound data structures available to you -- Array of Arrays; Hash of Arrays, etc. Either approach should work well.

If you Super Search with the terms seen unique you'll find some quite helpful nodes.

PS: Your problem statement implies that you're prepared to abandon the content of the "Effect" column. If that's not so, you'll want to make that clear with an update to your OP.

Update: tweaked first sentence for clarity.