 <p>You can do this using the excel concatenate function. Here's a link to a <a href="http://office.microsoft.com/en-us/excel-help/concatenate-HP005209020.aspx" rel="nofollow">good tutorial</a></p> <p>Also, to deal with the duplicates, you can have excel highlight duplicate entries so they can be easily deleted. <a href="http://office.microsoft.com/en-us/excel-help/locate-duplicates-by-using-conditional-formatting-HA001136616.aspx" rel="nofollow">See here</a></p>