I would like to change the layout of a input CSV file and change the layout of values.
So the initial Format has headings like: - Customer Zone Type 1 2 3 4 5 6 7 8 9 10 11 12
Under the number headings are the budget figures for a specific period, there are quite a few entries like this.
Now in order to use this data in a more meaningful way within SSRS I need it in the format of
- Customer Zone Type Period Budget
Where the number is now underneath period and the figures are underneath budget.
Does anyone have any recommendations of software that will allow me to do this?
I was thinking that Excel VBA would let me do this, but I was unsure if it would or if there was a better alternative.