I received a large spreadsheet that is not in database format because it would not have fit. Basically, its a spreadsheet of product sales by store. There are over 4000 stores and those fields are fine. The problem is that there are over 200 items and each is its own field. If I import this table into Access, is there a way that I can create a new table in 3rd normal form?
I have attached a sample of the data.
Thanks for any help!