Download the featured file here:https://www.bluepecantraining.com/wp-content/uploads/2023/05/merge-data-from-duplicate-rows-in-excel-based-on-unique-column.xlsx

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.

The video looks at two methods you can use to achieve this. The first uses the SORT, UNIQUE and TEXTJOIN functions which are available in Excel 365. The second method uses Power Query which will be available to the majority of users.

00:00 Introduction
00:35 TEXTJOIN Method
02:57 Power Query method