merge files with errors

hello everyone,

i am new to the platform, i would like to ask for some help. I need to merge several excel files that all have this structure: a first column with names and the second column with numeric values. what is the easiest way to merge them so that I have all numeric values side by side by name? (I tried concatenate but the resulting table multiplied the rows by first putting the list of names with the first value and the second one blank, then it starts over again always the first column with the names and puts me the first blank value and the second one written).

I have another problem, that in the different input excel files the first column with names is not the same for everyone. some columns have different lengths or the names are not exactly the same, i.e. for some there are errors such as: instead of writing Anna Maria there is Maria Anna, or instead of St. Anna there is Anna, St.

about the length, it is because some names are repeated with variations for example Anna Maria1 or they are sets, for example “woman”.

what is the easiest way to handle these problems?

I had thought of writing a column with the limited set of names I’m interested in but I wouldn’t know how to get it to do the checking and then how to handle the differences.