Basic Excel Question
 

Is there any way to make excel rearrange a row of data to a column of data?

Example: I want to rearrange this:

http://img120.imageshack.us/img120/1821/oldhd0.png

into this:

http://img120.imageshack.us/img120/7144/newag8.png

Re: Basic Excel Question
 

Maybe a Macro can help you.

Re: Basic Excel Question
 

Select and copy the cells you want to change to a row
Move to the cell you want to be the top of the column
Edit|Paste Special...
Click the Transpose check box to make a row a column or column a row.

Re: Basic Excel Question
 

Holy [censored] it works thank you!