Merging Dups but keeping certain data

Highlighted
Frequent 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
Highlighted

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