pivot tables in asp.net

Question

hello all
i am displaying some data from the databse. i want to chnge the format in which it is displayed.
i want to display rates associated with particular country. i can display the data like this
Australia: 10cents
UK:12 cents
US 5 cents
but can i display the data like this
Australia      UK          US
10 c           12 c         5 c

Thanks in advance
Vignesh