How do you change an Excel Row to a Column?

I can't believe how easy this actually is but until I knew I was left working out how to use formulas to do this, and you really don't need to. Initially, I was over the moon an quite proud having written a formula to do this but now I'm just red with embarassment - and as the KISS principal prevails!

Ok, so you have a row of data that would now like to work with as column. Firstly, just select the row of data you wish to convert and edit->copy. Select the cell you want you new column of data to start and use Edit->Paste Special (Or if you are using 2007 just use the right click over the cells you are working with) and then click the transpose checkbox on. Press OK and you are away! Easy eh?!!