Merging Combining variations

Good morning, good afternoon or good evening…wherever you may be…

Is there a way to merge attributes? I have a Dropbox folder from a supplier with 8 sub folders and each of those with 3-6 sub-sub folders and sub folders within those folders.

The problem is that within the 60-80 csv files in those folders they have ‘doubled up’ on their attributes with different spellings. Either by putting a space or using a capital letter in one and not the other. (and they have about 15 different attribute columns each)

For example,
Pin Size:
5/16×18,
5/16 x 18,
5/16×18 piloted. Thay should all be this one.

Weight:
17oz,
17.0oz and
17.0 oz.

Is there a way to merge these? Paid or not, I need to figure out how to update about 100,000 sku’s.

Thank you