Make report by making columns to rows?

[Morten NP]

I have a material part where I have a pre calculated cost in one table and actual cost in another table. Then I can compare these figures by making a normal query. The problem is though that I will get a result like this:

Material number ; Actual wage ; precalc wage ; actual mat ; precalc mat
XXXX2212 ; 10 ; 25 ; 10 ; 90

With more columns this will be difficult to get a quick overview of. Therefore I would like to convert it to something like:

Material number XXXX2212
---------- Pre calc ; actual cost
Wage ; 25 ; 10
Mat ; 90 ; 10

Is that possible and how do I do it?