How do you change the rows to columns and columns to rows.
 

Ok, I am stumped on how to do this?
I have a spreadsheed that has Dates in the A column and Data in the 1
row. I want to make is so, the data is in the A column and Dates run
accross in the 1 column. How can I do this?

Sound easy, but I am stumped??? :eek:


--
cc4digital
------------------------------------------------------------------------
cc4digital's Profile: http://www.excelforum.com/member.php...o&userid=26569
View this thread: http://www.excelforum.com/showthread...hreadid=398437

Highlight your data and copy it into the clipboard. Move to an open
spot in the spreadsheet and click Edit Paste Special, then select the
Transpose box and click OK. It takes a little getting used to, but
should do what you need.