Financial analysis import question

[dries_clairhout]

Good day, 

Attached is an Excel file.

The Titles should be the dimensions,

per dimension there are a number of account numbers.

Now the titles "OMZET", "DIV+FIN OPBRENGSTEN" etc. should be the dimensions.

Now the numbers would be linked as %key_Rekeningno to the existing structure.

So If i make a pivot table, I can include all the dimensions as said above, then underneath them should be the account numbers (also as dimension I guess) and then the measures next to them per category.

Any ideas how i can accomplish this?

Visual example in second image

Thanks in advance,

DC