combine duplicate rows based on a column

Hi tho,

I think you should rethink this problem. I believe a Pivot Table using Names and Dates as the rows is a much better format for your answer. I don't see how you can have two different dates on the same row as your problem suggests (in your answer). I can show you what I mean if you attach a sample workbook.