I have 47,000 records with 35 fields in each record. I have many duplicates where the company name, address, and phone are the same. I'll use XYZ Company as an example.
Record 1 through 10 are the same as far as the first 10 fields go. Then I have fields 11 through 35 that have a Y, 1, 2, 3, 4, 5, or are blank. Record 1 might have a Y in fields 14 and 22 but blank in the rest and Record 2 might have a 3 in 23 and 28 but the rest are blank. I would like to be able to merge the records into one based on the company's name with fields 11 through 35 including any Y,1,2,3,5, or blanks from the 10 duplicate records. I obviously do not want to overwrite a value that is in one record with a blank from the next record. In the end, I want there to be one record of XYG company and showing a Y in fields 14 and 22 and a 3 in fields 23 and 28.
Thoughts?
FYI....I'm using a purchased copy of Professional 2.3