| 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 |
| 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 | |||
Threaded Mode
