Assembling data in excel

[witsend75]

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?

[mehmetcik]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.