Forum Discussion

Merrilily7's avatar
Merrilily7
Copper Contributor
Sep 03, 2020

Merging Dups but keeping certain data

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

  • PReagan's avatar
    PReagan
    Bronze Contributor

    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