How to convert data in rows to columns like time series format

[Guest]

Hello everyone

I have an interesting question.How can i convert data in rows to columns as
in time series format

Example

Day Hours
1:00 2:00 3:00 4:00 5:00
......................................24:00
2/1/2007 12 10 15 19 25
.........................................14
2/2/2007 10 10 14 20
32.........................................16


to this format

Day hour readings
2/1/2007 1:00 12
2:00 10
3:00 15
4:00 19
5:00
...

 

[Guest]

You can use a union query. If you don't find this response useful, come back
with specific table and field names.