Converting "spreadsheet view" to database structure

[adam kennedy]

Dear group,

Can anyone here offer a line(s) of SQL that will do the following format conversion (see below)? Thanks in advance.

Convert from this format …
time, height1, height2
1, q, a
2, w, s
3, e, d
4, r, f
5, t, g

To this format with SQL …
time, height, value
1, 1, q
2, 1, w
3, 1, e
4, 1, r
5, 1, t
1, 2, a
2, 2, s
3, 2, d
4, 2, f
5, 2, g