How to make a special qlikview table

[#1]

I have source data as below image (A) and I would like to turn the source data into qlikview format as below image (B).

Any idea how make the qlikview table into that format (B)?

Thanks

[lironbaram]

hi

you'll need to load the table in two steps

something like

Data:

Crosstable(Type,Amount,2)

Load Product,

         ProductCode,

          Unit,

          Value

from SourceTable;

join(Data)

Crosstable(Type,Budget,2)

Load Product,

         ProductCode,

          BudgetUnit,

         BudgetValue

from SourceTable;