Help with consolidating multiple records into one
I have a database that has multiple records that I need to reduce down to one record as below:
Input:
SSN name --- ---
SSN --- address ---
SSN --- --- phone
SSN2 name --- ---
SSN2 --- address ---
SSN2 --- --- phone
Output:
SSN name address phone
SSN2 name address phone
It seems that I have the same number of records (6) for each SSN and I am copying the data from each field into the same field position on the output record. I have over 100K records to fix. Can be done in Excel or Access. Data is tab delimited text.
Thanks for your help.
|