Home

Combine rows with duplicate text in column A without losing text in columns B-E

%3CLINGO-SUB%20id%3D%22lingo-sub-326140%22%20slang%3D%22en-US%22%3ECombine%20rows%20with%20duplicate%20text%20in%20column%20A%20without%20losing%20text%20in%20columns%20B-E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326140%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%208%2C000%20row%20spreadsheet%20where%20there%20are%20duplicates%20in%20Column%20A%20and%20I%20want%20to%20combine%20the%20duplicate%20rows%20into%20a%20single%20row%20without%20losing%20the%20text%20in%20the%20rows%20to%20the%20right%20(Columns%20B-E).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326140%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331978%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20rows%20with%20duplicate%20text%20in%20column%20A%20without%20losing%20text%20in%20columns%20B-E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331978%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20not%20want%20to%20thread%20jack%20but%20I%20think%20the%20OP%20is%20having%20the%20same%20issue%20I'm%20having.%20I%20have%20attached%20an%20example%20of%20what%20I%20am%20trying%20to%20do%20and%20our%20problems%20might%20match%20up.%20The%20right%20column%20(B)%20has%20my%20duplicate%20numbers%20which%20correlate%20to%20batches%20of%20serial%20numbers%20in%20column%20(A)%20that%20I%20need%20to%20keep.%20Max%20three%20pieces%20per%20batch.%20Any%20idea%20on%20how%20to%20use%20the%20sort%20function%20or%20other%20to%20not%20lose%20the%20serial%20numbers%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326216%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20rows%20with%20duplicate%20text%20in%20column%20A%20without%20losing%20text%20in%20columns%20B-E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326216%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20you%20mean%20you'd%20like%20to%20merge%20duplicated%20cells%20in%20column%20A%20keeping%20cells%20in%20other%20columns%20as%20they%20are%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326209%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20rows%20with%20duplicate%20text%20in%20column%20A%20without%20losing%20text%20in%20columns%20B-E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326209%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272620%22%20target%3D%22_blank%22%3E%40AllenK2019%3C%2FA%3E%20!%3C%2FP%3E%3CP%3EFirst%3A%20You%20can%20do%20an%20advanced%20filter%20in%20your%20excel%20workbook%20to%20copy%20a%20unique%20selection%20on%20another%20range%20of%20the%20same%20sheet.%20Steps%20to%20do%20this%20are%3A%201.%20Go%20to%20your%20%22DATA%22%20Tab%20-%26nbsp%3B%20search%20for%20a%20button%20called%20%22Advanced%22.%202.%20There%20you%20see%20a%20dialogue%20as%20screenshot%20attached%20here.%203.%20Click%20OK.%204.%20Enjoy%20your%20unique%20filter%20%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%3A%20Only%20you%20can%20decide%20which%20rows%20are%20the%20actual%20ones.%20There%20is%20no%20Excel%20tool%20whitch%20does%20know%20without%20versioning%2C%20which%20one%20of%20your%20duplicate%20rows%20is%20the%20latest%20saved%20one.%20Unless%20you%20have%20saved%20it%20within%20OneDrive%20or%20SharePoint%2C%20which%20do%20the%20versioning%20automatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E
AllenK2019
Occasional Visitor

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).

3 Replies
Highlighted

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.

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?

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies