Merge Duplicate Rows in Excel Combining Unique Values in One Cell

Microsoft Excel Tips and Tricks

In this Microsoft Excel video tutorial I demonstrate how to merge or combine duplicate records into one cell without losing unique data. In my example, I have a book club: each book that has been read by a book club member is entered in a separate row in the database. I want each book club member listed once, with a list of all the books they have read in a single cell.

Credit Chester Tugwell