Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following table layout:
Article | 20110110 | 20110117 | 20110120 |
---|---|---|---|
Icecream | 15 | 0 | 32 |
Hotdog | 2 | 0 | 0 |
And I would like to convert it into the following layout:
Article | Date | Volume |
---|---|---|
Icecream | 20110110 | 15 |
Icecream | 20110120 | 32 |
Hotdog | 20110110 | 2 |
I have thousands of lines so i need som kind of automated algorithm to do this.
Thanks!
Solved it by myself through using the crosstable function in the load script, thanks anyway!
Solved it by myself through using the crosstable function in the load script, thanks anyway!