Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE
I HAVE A SPREADSHEET WITH EMPLOYEE NAMES AND HOURS WORKED. EACH EMPLOYEE HAS
MULTIPLE LINES WITH FOUR COLUMNS. I WANT TO HAVE EACH EMPLOYEE HAVE ONE LINE AND ANY NUMBER THAT IS IN THE SAME COLUMN ADD TO OTHER NUMBER IN THE SAME COLUMN FOR THAT EMPLOYEE. NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 12.00 ABRAMS, JAMES 10.00 0 11.5 ACKER, EDWARD 12.22 11.50 ACKER, EDWARD 10.00 0 1 ADAMS, CLIFTON 13.00 12.50 ADAMS, CLIFTON 0 11.5 ADAMS, JAMES 12.33 11.50 ADAMS, JAMES 0 1 I CAN HAVE HUNDREDS OF LINES. I WANT THE OUTCOME TO LOOK LIKE THIS: NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 22.00 0 11.5 ACKER, EDWARD 12.22 22.50 0 1 ADAMS, CLIFTON 13 12.50 0 1 ADAMS, JAMES 12.33 11.5 0 1 IF THERE IS A FORMULA THAT CAN DO THIS OR A MACRO, PLEASE HELP. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE
Sort your data by the name field.
Then use data|subtotals (in xl2003 menus) to add the numeric fields. You can use the outlining symbols to the left to hide/show the details. MAD101 wrote: I HAVE A SPREADSHEET WITH EMPLOYEE NAMES AND HOURS WORKED. EACH EMPLOYEE HAS MULTIPLE LINES WITH FOUR COLUMNS. I WANT TO HAVE EACH EMPLOYEE HAVE ONE LINE AND ANY NUMBER THAT IS IN THE SAME COLUMN ADD TO OTHER NUMBER IN THE SAME COLUMN FOR THAT EMPLOYEE. NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 12.00 ABRAMS, JAMES 10.00 0 11.5 ACKER, EDWARD 12.22 11.50 ACKER, EDWARD 10.00 0 1 ADAMS, CLIFTON 13.00 12.50 ADAMS, CLIFTON 0 11.5 ADAMS, JAMES 12.33 11.50 ADAMS, JAMES 0 1 I CAN HAVE HUNDREDS OF LINES. I WANT THE OUTCOME TO LOOK LIKE THIS: NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 22.00 0 11.5 ACKER, EDWARD 12.22 22.50 0 1 ADAMS, CLIFTON 13 12.50 0 1 ADAMS, JAMES 12.33 11.5 0 1 IF THERE IS A FORMULA THAT CAN DO THIS OR A MACRO, PLEASE HELP. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE
Say your names are in Col 2, beginning row 2, and data in cols. B,C,D,E
Use the Data, Advanced Filter command to create a list of unique names in Col. F In G2, insert this fomula: =SUMIF($F2,"="&A:A,B:B) Copy across to cols H,I,J and down for as many rows as there are names in Col. F -- TedMi "MAD101" wrote: I HAVE A SPREADSHEET WITH EMPLOYEE NAMES AND HOURS WORKED. EACH EMPLOYEE HAS MULTIPLE LINES WITH FOUR COLUMNS. I WANT TO HAVE EACH EMPLOYEE HAVE ONE LINE AND ANY NUMBER THAT IS IN THE SAME COLUMN ADD TO OTHER NUMBER IN THE SAME COLUMN FOR THAT EMPLOYEE. NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 12.00 ABRAMS, JAMES 10.00 0 11.5 ACKER, EDWARD 12.22 11.50 ACKER, EDWARD 10.00 0 1 ADAMS, CLIFTON 13.00 12.50 ADAMS, CLIFTON 0 11.5 ADAMS, JAMES 12.33 11.50 ADAMS, JAMES 0 1 I CAN HAVE HUNDREDS OF LINES. I WANT THE OUTCOME TO LOOK LIKE THIS: NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 22.00 0 11.5 ACKER, EDWARD 12.22 22.50 0 1 ADAMS, CLIFTON 13 12.50 0 1 ADAMS, JAMES 12.33 11.5 0 1 IF THERE IS A FORMULA THAT CAN DO THIS OR A MACRO, PLEASE HELP. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE
Capital letters sounds very bad........
select your all data press F5 click on special button and select blank cells only. type zero and hit CTRL+ENTER (it will populate all blank cells with zero). Now use a pivot table to get the result you are looking for. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "MAD101" escreveu: I HAVE A SPREADSHEET WITH EMPLOYEE NAMES AND HOURS WORKED. EACH EMPLOYEE HAS MULTIPLE LINES WITH FOUR COLUMNS. I WANT TO HAVE EACH EMPLOYEE HAVE ONE LINE AND ANY NUMBER THAT IS IN THE SAME COLUMN ADD TO OTHER NUMBER IN THE SAME COLUMN FOR THAT EMPLOYEE. NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 12.00 ABRAMS, JAMES 10.00 0 11.5 ACKER, EDWARD 12.22 11.50 ACKER, EDWARD 10.00 0 1 ADAMS, CLIFTON 13.00 12.50 ADAMS, CLIFTON 0 11.5 ADAMS, JAMES 12.33 11.50 ADAMS, JAMES 0 1 I CAN HAVE HUNDREDS OF LINES. I WANT THE OUTCOME TO LOOK LIKE THIS: NAME TRACK TRACK PP HRS ABRAMS, JAMES 12.82 22.00 0 11.5 ACKER, EDWARD 12.22 22.50 0 1 ADAMS, CLIFTON 13 12.50 0 1 ADAMS, JAMES 12.33 11.5 0 1 IF THERE IS A FORMULA THAT CAN DO THIS OR A MACRO, PLEASE HELP. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine multiple workbooks with same structure data | Excel Discussion (Misc queries) | |||
How do I combine multiple rows with like data in Excel? | Excel Discussion (Misc queries) | |||
Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
combine data from multiple sheets | Excel Discussion (Misc queries) |