merge tables

[efeedback]

I have contact data for 4 contacts in one record, i.e. on one line in a table; although there are 4 contacts separate contacts they share the same phone number, address, etc.

I would like to get each contact into a separate record with is associated phone number, address, etc.

I have tried creating 4 copies of the same table and then merging with a query but got lost.

I have tried an append query but the access help is useless.

Any ideas??

 

[guybrush]

Here is probably what I would do

1-export the table to excel
2-add a bunch of new columns to the right of the column containing the
redundant contact information.
3-use the Data->Text To columns feature to separate all of the names into different columns.
4-import the table back into access
5-now make 4 copies of the table, and delete one column from each.
6-Finally, use a union query to append all of the data to one of the tables (or a fresh new table).

Hopefully, you don't need to do this more than once :wink:
(If you do, I am sure there is a cleaner way to do this).