| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if row has duplicates, concat entries in another column?
I'm new to Excel, and struggling with compiling multiple duplicate rows, example:
col1 col2 Mark Robbery Mark Murder Mark Arson John Assault John DUI Dan Murder The result I want is: col1 col3 Mark Robbery, Murder, Arson John Assault, DUI Dan Murder Any help would be appreciated! Last edited by rchun : May 14th 13 at 09:21 PM Reason: clarification |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list of entries from a column without duplicates | Excel Worksheet Functions | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
| Concat values in two or more rows based on id and eliminate duplicates | Excel Programming | |||
| Summing duplicate entries and non duplicates | Excel Programming | |||
| Copy multiple entries and paste without duplicates | Excel Programming | |||
Threaded Mode
