I have a table of data that is an export from a phone that I want to import into Outlook.
The problem is that for every different phone number I have a new record in the table.
EX. Ron Jones cellphone is line 1 Ron Jones Home phone is line 2, Ron Jones Pagor is line 3. If I import this into Outlook it will create 3 separate entries or records for Ron Jones.
I need to somehow bring together all the like records with all the phone numbers. Therefore Ron Jones will have his name and cell, home and pagor # on one record.
Any ideas would be appreciated.

Access would do it easily by importing the whole file. Create a names table with the Name as Unique. Append the names to the table using an append query which removes all duplicates and then use an update query to update the names with the phone numbers in their appropriate fields.

You could do this programmatically from within Excel. If this is already where you have the data, I'm not so sure it'd be more advantageous to port to Access and then back to Outlook. But I would have to see your data structure.

Also, which version(s) of Excel/Outlook are you running?