display data column wise

[selva]

hi

 

i want to generate a report like this.

 

 

1 2

district boys girls boys girls

chennai 40 36 34 35

erode 34 78 67 78

 

 

 

but i got

 

district boys girls standard

chennai 40 36 1

erode 34 78 1

chennai 34 35 2

erode 67 78 2

 

how to i get that format?plz give sol.

 

 

thanks in advance,

selva