I have sets of data to combine in Excel 2010. Each data set has the name of the member e.g. "Alan Andrews" in row 2 column 1 and results for Alan Andrews in two further columns. The data set is in alpha order of member name and there are about 400 rows.
However the membership list and total number of members changed several times during the year that the data sets were captured. Thus in one data set Jon Wall may be row 370 and in another he may be row 372.
There are 20 data sets
I wish to create a single list in which all the names will appear in column 1 in alpha order and there will be up to 40 columns of data against each name.
I am not into VBasic. Any suggestions please?