Search for Records with Multiple Matching Fields

I have a set of raw data being imported from a spreadsheet that needs to be aggregated into an arbitrary set of groups. I would like to find any records with matches in certain fields (3-5 fields), and identify them as belonging to the same group. There will be several groups identified through this search, and I plan to have these become parent records with the original raw data as child records (though I'm open to other approaches) to allow me to view and summarize the data from non-matching fields of the records within each group. There are many options for values in the fields to be checked for matches, so I do not want to simply identify all the possible combinations and use a long if statement to assign to a group for obvious reasons.

Is there an efficient way to find all records with equal values in multiple fields, somehow flag them as belonging together, and automatically create a parent record for the group? Subsequently, I may need to move data between groups manually or split off some of the automatically grouped records as their own group, so I don't want to use formulas to define which parent the records belong to. Any thoughts would be appreciated!

------------------------------
Oana Toma
------------------------------