Transpose columns into continuous rows

  • Thread starter Thread starter PattiP
  • Start date Start date
P

PattiP

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.
 
Back
Top