Forum Discussion
Combine rows with duplicate text in column A without losing text in columns B-E
I have a 8,000 row spreadsheet where there are duplicates in Column A and I want to combine the duplicate rows into a single row without losing the text in the rows to the right (Columns B-E).
hello AllenK2019 !
First: You can do an advanced filter in your excel workbook to copy a unique selection on another range of the same sheet. Steps to do this are: 1. Go to your "DATA" Tab - search for a button called "Advanced". 2. There you see a dialogue as screenshot attached here. 3. Click OK. 4. Enjoy your unique filter :)
Second: Only you can decide which rows are the actual ones. There is no Excel tool whitch does know without versioning, which one of your duplicate rows is the latest saved one. Unless you have saved it within OneDrive or SharePoint, which do the versioning automatically.
Greets, Eva.
