Horizontal to vertical Grid.

Question

Hi

I am looking for way to transpose from Horizontal grid to Vertical. Is it possible?

For example:
The database has fields 1 2 3 4 5 6 and corresponding data to the fields. So if I put a datagrid and connect it to the database I will get what ever data is shown in the database which is horizontal way

1    2   3   4   5
10 20 30 40 50

but I would like the above to be shown in vertical way (Transpose). As shown below:

  1                   10
  2                   20
  3                   30
  4                   40
  5                   50

Is this possible? if so how?

Awaiting your response!

Thanks!