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).
Do you mean you'd like to merge duplicated cells in column A keeping cells in other columns as they are?
Do not want to thread jack but I think the OP is having the same issue I'm having. I have attached an example of what I am trying to do and our problems might match up. The right column (B) has my duplicate numbers which correlate to batches of serial numbers in column (A) that I need to keep. Max three pieces per batch. Any idea on how to use the sort function or other to not lose the serial numbers?
