Spreadsheet previously modified by Got It Pro.
Rows 1 - 11,841 are correct.
I've color coded an EXAMPLE of how 3 ROWS for EACH REAL ESTATE CONTACT Need to ALL MERGE INTO ROW 1 of 3. This will require Formulas and Mapping Fields as done before by a PREVIOUS TECH. LOOK at ROWS 11,843 - 11,848 to see the COLOR CODED EXAMPLE. Then MODIFY THE SPREADSHEET and DELETE ALL ROWS THAT are now EMPTY because the ROWS have been CONSOLIDATED FROM 3 TO 1.
Solved by E. E. in 26 mins