I was wondering if anyone could help me get my head around this problem that I'm having, I have an Excel spreadsheet with the following layout.
Area |ID |Location |Week1 |Week2 |Week3+
71 |1484 |Rochdale |713 |728 |690
71 |1485 |Doncaster |713 |728 |690
How would I best structure an SQL table to store these, that I could then easily retrieve and display in html?
Any help would be greatly appreciated.
At its most basic:
Area|ID |Location |Week |Value
Further optimisation might be required