On Tuesday, May 14, 2013 4:20:25 PM UTC-4, rchun wrote:
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!









--

rchun

The Merge Assistant, http://www.add-ins.com/product_list.htm will do exactly what you want done