Prepare an excel file of 20,000 records for upload into database. Combine lists into a master file. Overlay data between duplicate records to create one complete record and remove duplicates. Overlay data from separate excel files onto master file including customer id, sales person name, city, state and zip code, assign salesperson id # to salesperson name, and campaign descriptions from other excel docs. Separate area code from phone column to a separate column and convert any formulas to raw data.