Go with Michael's suggestion - you really need to normalise the database structure before you do anything.

How are you consolidating the data from your spreadsheets into your database? There may be an option whereby you can import the data using its current structure, then append from there to a normalised table structure.