Modify table according to value list

[capriconuser]

I have a table like this 

name	a_col sum	a_col count	b_col sum	b_col
	20541	46	68560	149
a	3141	9	2139	6
b	8400	21	10846	29
c	9000	16	55575	114

now i want this table like this 

name                          trans       count     sum 

a        reserved        a_col       9             68560

                                     b_col     6             2139

here i want to add reserved in value list like i want to create dummy one  same goes for count and sum

.. not be suppose to come from table

so how i structure of modify table like above ?

[mdmukramali]

Hi,

have to try with Cross Table concept in the Script level?

[capriconuser]

no.. i dont have idea cross table.. and i dont want to create cross table in script level ..

there is
valuelist ('Count','Sum')
now i want expression of count and sum according to these like this

count sum
a_col //here should be values according to count and sum
b_col


hope you understand..

[capriconuser]

any help please