Hello,
I have to load data from excel with a specific format. i need help. am attaching the sample excel and expected output below:
Expected Output:
| SheetName | Dim2 | Date | Data |
|---|
| AAA | ABC1 | 1/1/2013 | 100 |
| AAA | ABC1 | 1/2/2013 | 200 |
| AAA | ABC2 | 1/1/2013 | 300 |
| AAA | ABC2 | 1/2/2013 | 400 |
| AAA | ABC3 | 1/3/2013 | 500 |
| AAA | ABC3 | 1/4/2013 | 600 |
| BBB | BCD1 | | 1 |
| BBB | BCD1 | .. | 2 |
| BBB | BCD1 | | 3 |
| BBB | BCD2 | | 4 |
| ... | ... | | |
.
Note: The number of sheets and number of columns are not fixed. so i would require a dynamic solution.
Any help is much appreciated.
Regards,
Amit
