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
|