convert rows of dat in to columns?

[grahamnet]

Can anyone help.
thisis my problem
i have a table that looks something like this.

a b c d e
1 2 2 5 6

i would like to convert the table to look like this.

a 1
b 2
c 2
d 5
e 6

any ideas as to where i should start?
ta!

 

[PHV]

You want to change your database schema or a query result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[grahamnet]

the info is in a table that is automatically entered from another application in to the table

so i cant really change the format of that table.

so i guess what i want to change is a query result (i think)!!