Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I COMBINE two spreadsheets into one by names in column a
I have twi spreadshees that havethe 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. 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 ABRAMS, JAMES 11.50 ACKER, EDWARD 8 ADAMS, CLIFTON 12.50 ADAMS, JAMES 11.50 ADAMS, JENNIFER 11.50 ALBERSON, OWEN 11.50 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 ABRAMS, JAMES 0 11.5 11.50 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine 200 spreadsheets | Excel Discussion (Misc queries) | |||
How do I combine spreadsheets? | Excel Discussion (Misc queries) | |||
Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
how do i combine two separate spreadsheets? | Excel Discussion (Misc queries) | |||
Combine two spreadsheets with Different column headings | Excel Discussion (Misc queries) |