Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could anybody help?
Hope, somebody can help.