Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2006, 01:02 PM
wbiggs2 wbiggs2 is offline
Novice
Help with consolidating multiple records into one
 
Join Date: Nov 2006
Posts: 1
wbiggs2
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with consolidating multiple records into one 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
Help with consolidating multiple records into one pagination troubleshooting with multiple sections Katy D'Angelo Word 11 09-28-2006 12:13 PM
Help with consolidating multiple records into one 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft