GRIDVIEW or DATAGRID question

I need a way to basically take a GridView or DataSet control and turn the
data on its side, so the data will be shown vertically instead of horizontally.

I load the data from a DataSet object, so I can do it from the DataSet, if that's possible.

Does anyone know how to do this?

Explain 'vertically' in this context. Maybe a drawing or something.

Basically, pivot the table on its side, like this:


Sample table:

Name AccountID PhoneNumber
-------------------------------------
John 123 x5555
Bob 324 x1234


convert to:


Name John Bob
AccountID 123 324
PhoneNumber x5555 x1234