View Single Post
  #1   Report Post  
rchun rchun is offline
Junior Member
 
Posts: 2
Default 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