moving several columns into 1 continuous column

[PattiP]

Using office 2007, we receive 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.


we would like to convert the data to be in continuous rows by date, then
Hour to be able to graph it and other analysis 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.

I'm thinking maybe the OFFSET() function, but not understanding how to write
it. Thanks!

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Table Header to PT Row Field.
No formulas to write.
http://www.mediafire.com/file/imzywz3l2wd/04_24_09a.xlsx

 

[Hardeep kanwar]

Gr8 Herbert Seidenberg

But What if someone like me whose Working in 2003

Thanks in Advance

 

[Herbert Seidenberg]

Degraded to Excel 2003:
http://www.mediafire.com/file/yngy52o2ezm/04_24_09a.xls