Transpose columns into continuous rows
I have a large table with the following columns: Date, DayOfWeek, Hour1,
Hour2€¦.Hour24:
Date HE01 HE02 €¦ HE24
10/1/08 Wed 322 317 314
10/2/08 Thu 333 328 323
Etc.
I would like all the data to be in continuous rows by date, then Hour as
follows:
10/1/08 Wed HE01 322
10/1/08 Wed HE02 317
..
..
10/1/08 Wed HE24 314
10/2/08 Thu HE01 333
10/2/08 Thu HE02 328
..
..
10/2/08 Thu HE24 323
Etc.
--
Patti
|