Pivot table display in Jasper server 4.0 CE

[mandm]

 Hi All,

I find this forum very useful so time and again i keep asking questions which are unsolvable by me, so i have a query and its output is 

qtr, count, name1, name2, name3

1     23        A             B             C

2    44        f                G            H

and i want the report to display it as 

 

label        data1    data2

qtr            1                2

count       23              44

name1   A                 f

name2   B               G

name3    C               H

 

please suggest me an alternative if this is possible?