How to convert flatfile to relational database
I have single spreadsheet consisting of names of people in the rows and a column for each of 20 companies. If a person is connected to a company, the corresponding cell contains a "Y." Some people can belong to more than one company and each company can have more than one person (multiple to multiple relationship).
I created a database consisting of three tables: people, companies and joint. They're linked by company_id and individual_id in the joint table.
Is there an easy way to turn this flat file into a relational database? I don't want to have to rekey the connections.