title: Combining duplicate entries with unique data in Excel
body: <p>I have an Excel database and I'm trying avoid doing some manual combining of duplicate data. I've got a bunch of listings that are essentially the same aside from the tags column. What I'd like to have it do is combine these 5 listings into 1 listing, making the categories a comma separated list in a single cell.</p>
  
  <p>Turn this</p>
  
  <p><img src="https://i1113.photobucket.com/albums/k501/modsuperstar/ScreenShot2013-04-01at85740PM_zps71f07491.png" alt="Data Example"></p>
  
  <p>into this</p>
  
  <p><img src="https://i1113.photobucket.com/albums/k501/modsuperstar/ScreenShot2013-04-01at90443PM_zps7f15a378.png" alt="Desired result"></p>
  
  <p>Is there any way of achieving this? My document has a couple thousand listings, so I'm obviously trying to avoid the manual edit route. I'm an Excel novice, so any hand holding or tutorials you could point me to would be appreciated.</p>