Data structuring problem with monthly fact data in columns

[theike]

Hello all

I have the following problem in PowerPivot and I really don't know how to fix this (I admit I still have not much experience in PowerPivot).

The data is structured as follows:
​

1. column 1 contains characteristic 1 (man / female);​
2. ​
   colu​
   mn 2 contains characteristic 2 (containing 22 professions);​
3. column 3 contains characteristic 3 (containing 5 age buckets); ​
4. column 4 contains characteristic 4 (containing 16 unique financial elements);​
5. column 5 contains characteristic 5; ​
6. column 6 contains the YEAR​
7. columns 7:18 contain the monthly fact data given characteristics 1,2,3,4 and the YEAR. ​

I now want to structure the dataset in such way the first column 7 (containing the loss figures for January) is not a column anymore but a row while maintaining the characteristics in columns 1,2,3, and 4 for each of their unique element . In this proces I can forget about characteristic 5. This implies that I can can sum the losses over characteric 5, but need to maintain the detail for characteristics 1-4.

For example I then get:
Profession 1, age bucket 1, financial element 1, YEAR, losses for January in column 7 given profession 1, age bucket 1, financial element 1, YEAR
Profession 2, age bucket 1, financial elemement 1, YEAR, losses for Jauary in column 7 given profession 2, age bucket 1, financial element 1, YEAR
....
Profession 22, age bucket 1, financial elemement 1, YEAR, losses for Jauary in column 7 given profession 22, age bucket 1, financial element 1, YEAR

Profession 1, age bucket 2, financial element 1, YEAR, losses for January in column 7 given profession 1, age bucket 2, financial elemenet 1, YEAR
etc etc


Hope this is more or less clear. I admit I am a PowerPivot beginner, and really don't know where to start with this problem.

Thanks!​