Given an Excel spreadsheet with the following layout:
| DateTime | CompanyA | CompanyB | CompanyC |
|---|
| 1/2/2014 10:00:00 AM | 5 | 1 | 0 |
| 1/3/2014 05:00:00 AM | 10 | 3 | 2 |
| 1/4/2014 12:20:00 AM | 3 | 5 | 2 |
| 1/5/2014 8:33:30 PM | 2 | 0 | 1 |
Is it possible to load the above sheet in a single load statement such that I end up with the following model:
| Table1 |
|---|
DateTime |
| CompanyName |
| Data |
In the above case I would expect the resulting table to have 12 rows of data. Or do I have to load each company separately?
