How to Convert collums of data to rows

[ganoudij]

Sounds simple, but I can't seem to figure it out. I want
to convert collumnar data into rows to use in a 3D
graphing application.

For example, I want to covert data like this:

Date Time kW
Tuesday,March 23,2004 7:30 501
Tuesday,March 23,2004 8:00 526
Tuesday,March 23,2004 8:30 504

To data like this:

Time
Date 7:30 8:00 8:30
Tuesday,March 23,2004 501 526 504

TIA

Julian

 

[Debra Dalgleish]

You could build a pivot table from the data, with Date in the
row area, Time in the Column area, and kW in the data area.

There are instructions and links for pivot tables on Jon Peltier's site:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[ganoudij]

Thanks, Debra...I'll try it!

You could build a pivot table from the data, with Date in the
row area, Time in the Column area, and kW in the data area.

There are instructions and links for pivot tables on Jon Peltier's site:

http://peltiertech.com/Excel/Pivots/pivotstart.htm