Basic Excel Question

[yellowbastard]

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

Example: I want to rearrange this:



into this:

[firefarter]

Maybe a Macro can help you.

[Vern]

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.

[yellowbastard]

Holy [censored] it works thank you!