combining two spreadsheets with a common field


M

MAD101

I have two spreadsheets that have the same employee names. One spreadsheet
has the employee names in column a and overtime hours in column b, and
standard hours in column c. The second spreadsheet has the employee names in
column a and track hours in column b and track overtime hours in column c. I
want to combine these two spreadsheets to where the employees with same name
will have their hours all in one row.


Ex.
Name track_reg track ot
ABRAMS, JAMES 11.50 3
ACKER, EDWARD 8 1
ADAMS, CLIFTON 12.50 2
ADAMS, JAMES 11.50 1
ADAMS, JENNIFER 11.50 3
ALBERSON, OWEN 11.50 1

Name OT ST
ABRAMS, JAMES 0 11.5
ACKER, EDWARD 0 11.5
ADAMS, CLIFTON 5 8
ADAMS, JAMES 0 11.5
ADAMS, JENNIFER 0 11.5
ALBERSON, OWEN 0 11.5


I would like the hours to all in one row for each employee.

Ex:
Name OT ST track_reg track ot
ABRAMS, JAMES 0 11.5 11.50 3
 
Ad

Advertisements

S

ShaneDevenshire

Hi,

Use the Data, Consolidate command with Labels in Top row and Left column
turned on.

Start the process on a new sheet, choose the command, with the Reference box
active click the sheet tab where on set of data is and highlight all the data
including the titles at the top and the Names on the left and click Add.
With the cursor still in the Refernce box click the other sheet tab and
select the second range just like you did the first one, and click Add. Turn
on the two options I mentioned above. Click OK.

This process requires that the names and the tiltles at the tops of the data
columns be spelled consistantly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top