#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combine Records when Mail Merge from Access | Tom Pickles | Misc | 2 | 08-24-2010 06:00 PM |
Multiple Folders in Outlook | Cabbage1031 | Outlook | 0 | 05-23-2007 10:56 AM |
pagination troubleshooting with multiple sections | Katy D'Angelo | Word | 11 | 09-28-2006 12:13 PM |
Multiple criteria in SUMIF? | pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
import multiple categories | stormin.norm | Outlook | 0 | 01-30-2006 01:36 PM |