| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine multiple rows with like data in Excel?
I dont know what this would be called or what formula to use and would
greatly appreciate any help I can get. I would like to take the example table below and get the following results. First Last Address Previous Employer Steve Smith 166 Home St 4 I would like one row with the like data listed and a count if possible of the non like data. First Last Address Previous Employer Steve Smith 166 Home St ABC Inc Steve Smith 166 Home St #1 Times Steve Smith 166 Home St Any Work Steve Smith 166 Home St Work Now -- Chad Welch NG&G Facility Services |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I combine multiple rows with like data in Excel?
You could use a pivot table to summarize the data.
Put the First, Last and Address fields in the Row area, and Employer in the Data area, where it will become Count of Employer. There are pivot table instructions and links he http://www.contextures.com/xlPivot01.html CAW@NG&G wrote: I dont know what this would be called or what formula to use and would greatly appreciate any help I can get. I would like to take the example table below and get the following results. First Last Address Previous Employer Steve Smith 166 Home St 4 I would like one row with the like data listed and a count if possible of the non like data. First Last Address Previous Employer Steve Smith 166 Home St ABC Inc Steve Smith 166 Home St #1 Times Steve Smith 166 Home St Any Work Steve Smith 166 Home St Work Now -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I combine multiple rows with like data in Excel?
I tried a pivot table function but I cannot get multiple columns to show. I
think a VB formula will give me the data that Im looking for but I just dont know all the command lines. First Last Address Previous Employer Steve Smith 166 Home St 4 -- Chad Welch NG&G Facility Services "Debra Dalgleish" wrote: You could use a pivot table to summarize the data. Put the First, Last and Address fields in the Row area, and Employer in the Data area, where it will become Count of Employer. There are pivot table instructions and links he http://www.contextures.com/xlPivot01.html CAW@NG&G wrote: I dont know what this would be called or what formula to use and would greatly appreciate any help I can get. I would like to take the example table below and get the following results. First Last Address Previous Employer Steve Smith 166 Home St 4 I would like one row with the like data listed and a count if possible of the non like data. First Last Address Previous Employer Steve Smith 166 Home St ABC Inc Steve Smith 166 Home St #1 Times Steve Smith 166 Home St Any Work Steve Smith 166 Home St Work Now -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
| How do I combine data from separate Excel rows | New Users to Excel | |||
| How to combine multiple rows of text cells into one cell | Excel Discussion (Misc queries) | |||
| Combine data rows in Pie Chart | Charts and Charting in Excel | |||
| how to combine the multiple rows into one rows? | Excel Worksheet Functions | |||
Linear Mode
