My data:

Column names a patientID, date, reading1, reading2....reading12
row1: 918273, 20090901, 12.1, 5.6, ......9.4
row2: 918273, 20090902, 8.3, 3.8, ......1.8
rows keep going...

I want the data to look like:
patientID, date, reading
918273, 01-Sep-09, 00:00, 12.1
918273, 01-Sep-09, 02:00, 5.6
..
..
..
918273, 01-Sep-09, 22:00, 9.4
918273, 02-Sep-09, 00:00, 8.3
918273, 02-Sep-09, 02:00, 3.8
..
..
..
918273, 02-Sep-09, 22:00, 1.8

So what's happening is there are 12 readings per day, I want the readings to
go down the page and add a column with the time so people know what time the
reading was taken. And keep adding the days down the worksheet. Is that
possible in excel?

Thanking you.
Diana