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:35 TEXTJOIN Method
02:57 Power Query method
Take the opportunity to connect and share this video with your friends and family if you find it useful.
Keywords: merge data from duplicate rows in excel based on unique column, merge duplicate rows in excel without losing data, how to combine duplicate rows into one keeping unique values only, combine duplicate rows in excel, excel merge duplicate rows text, how do i combine duplicate rows in excel with multiple columns, merge data from multiple rows into one cell, how do i merge data from multiple duplicate rows into one, merge duplicate rows in excel