Do you always have 12 entries--or should the macro check?

Where do you get the time values? I don't see them in your sample "before"
data. (Or do you just want an empty column so that you can fill them in
manually???)

Diana wrote:

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

--

Dave Peterson