Q:

How can I merge cells same data in Excel 2010?

I need to merge cells containing the same information and I'm new to Excel, so I could really use some help. Here's my situation. I was given 3 spreadsheets. The first with a User ID and a Department. The second has a User ID, First and Last name, and the third has a User ID and Roles. They aren't lined up in the same column, and I need to merge the User ID's into Column A and the other information to be in the same row without jumbling the information. 
To explain it another way, if the User ID in Column A matches a User ID in column D, I need Column D to merge with the cell containing the ID in Column A. Then I need the correct First name, Last name, Department, and any roles associated with that User ID to be placed in their respective places in that row. Please help! 
This is what the current spreadsheet looks like. The information I received in each spreadsheet is separated by black columns, but will be deleted. I put those in to understand where each set of data came from.

full image
This is what I want it to look like. The 2nd and 3rd role are only to be filled if a person has a 2nd/3rd role.

full image

A:

Here are the steps I used to tackled the problem:

Populate C2 and down (by dragging the fill handle) with the formula =Sheet2!A2
Populate B2 and down (by double clicking the fill handle) with the
formula =INDEX(Sheet2!B:B,MATCH(C2,Sheet2!A:A,0))
Populate A2 and down (by double clicking the fill handle) with the
formula =INDEX(Sheet2!C:C,MATCH(C2,Sheet2!A:A,0))
Populate D2 and down (by double clicking the fill handle) with the
formula =INDEX(Sheet1!B:B,MATCH(C2,Sheet1!A:A,0))
Populate E2 with the formula
=IFERROR(INDEX(Sheet3!$B:$B,SMALL(IF(Sheet3!$A:$A=$C2,ROW(Sheet3!$A:$A)),COLUMNS($E2:E2))),"")
which will need to be entered with Ctrl+Shift+Enter as it is an
array formula.
With cell E2 still selected drag the fill handle across to cells F2
and G2.
With cells E2, F2 and G2 still selected, double click the fill handle
to send the formulas down.

