Take a Flat file and make it into 2 realated tables
I have a Flat file with 10k records. It has a unique ID per row. I need to break it into 2 tables relating to each other.
The table has names and addresses. The names have unique ID's as well and addresses can be many. I would like to have Name table and Address table and keep them linked. This is just an example.
Unique ID----Name ID(unique as well) Addresses
1 200-Chuck 11 W 5th
2 200-Chuck 35 N St
3 100-Bill 11 W 5th
4 300-John 22 E 7th
5 300-John 35 N St