Merging Dups but keeping certain data

%3CLINGO-SUB%20id%3D%22lingo-sub-1632582%22%20slang%3D%22en-US%22%3EMerging%20Dups%20but%20keeping%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1632582%22%20slang%3D%22en-US%22%3E%3CP%3Ei'm%20trying%20to%20figure%20out%20how%20to%20merge%20duplicate%20rows%20but%20i%20only%20want%20certain%20data.%20How%20do%20I%20do%20that%3F%3C%2FP%3E%3CP%3Eexample%3C%2FP%3E%3CP%3Ehere%20are%20the%20two%20rows.%20The%20second%20row%20has%20email%20and%20phone%20number.%20I%20want%20all%20the%20data%20from%20row%201%20but%20only%20the%20email%20and%20phone%23%20from%20row%202%3C%2FP%3E%3CTABLE%20width%3D%221940%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22100%22%3EHarold%3C%2FTD%3E%3CTD%20width%3D%22155%22%3EBerry%3C%2FTD%3E%3CTD%20width%3D%2261%22%3E1332%3C%2FTD%3E%3CTD%20width%3D%22270%22%3EWindermere%20Real%20Estate%20Midtown%3C%2FTD%3E%3CTD%20width%3D%22225%22%3E7300%20E%20Green%20Lake%20Dr%20N%3C%2FTD%3E%3CTD%20width%3D%22125%22%3ESeattle%3C%2FTD%3E%3CTD%20width%3D%2267%22%3E98115%3C%2FTD%3E%3CTD%20width%3D%2238%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E4294744%3C%2FTD%3E%3CTD%20width%3D%2240%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E3913100%3C%2FTD%3E%3CTD%20width%3D%22213%22%3E9%3C%2FTD%3E%3CTD%20width%3D%22327%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22193%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHarold%3C%2FTD%3E%3CTD%3EBerry%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWindermere%20Real%20Estate%20Midtown%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3Etest%40test.com%3C%2FTD%3E%3CTD%3E(206)%20111-1111%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1632582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1633049%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20Dups%20but%20keeping%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1633049%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F781273%22%20target%3D%22_blank%22%3E%40Merrilily7%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20suggest%20using%20a%20Pivot%20table%20with%20the%20following%20layout%3A%3C%2FP%3E%3CUL%3E%3CLI%3ESubtotals%3A%20Do%20Not%20Show%20Subtotals%3C%2FLI%3E%3CLI%3EGrand%20Totals%3A%20Off%20for%20Rows%20and%20Columns%3C%2FLI%3E%3CLI%3EReport%20Layout%3A%20Show%20in%20Tabular%20Form%3C%2FLI%3E%3CLI%3EBlank%20Rows%3A%20Remove%20Blank%20Line%20after%20Each%20Item%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Regular Visitor

I'm trying to figure out how to merge duplicate rows but I only want certain data. How do I do that?

Example:

Here are two rows, the second row only has email and phone number. I want all the data from row 1 but only the email and phone# from row 2. 

HaroldBerry1332Windermere Real Estate Midtown7300 E Green Lake Dr NSeattle9811544294744539131009  
HaroldBerry Windermere Real Estate Midtown        test@test.com

(206) 111-1111

 

Is this possible to merge them and keep all data from row 1 and now add the email and phone onto it? I have a list of 15,000 I need to go through and trying to find a faster way than manually coping and pasting the email and phone on to the row with the most data.

1 Reply

Hello @Merrilily7,

 

I would suggest using a Pivot table with the following layout:

  • Subtotals: Do Not Show Subtotals
  • Grand Totals: Off for Rows and Columns
  • Report Layout: Show in Tabular Form
  • Blank Rows: Remove Blank Line after Each Item