Switch rows to columns

[RussChilds]

Hi,
How do I flip a spreadsheet so the rows become coloumns? Is this possible?

I work at a school and we have Ofsted in today & tomorrow - ahhhh!

Many thanks,
Russ

 

[EB08]

I'm not sure I understand what you're asking, but if you want to take values that are vertical (a1:a10 example) and make them horizontal (b1:k1). Copy a1:a10, click on b1 and go to pastespecial, tick "transpose" and hit enter. If thats not what you're looking for, try re-wording your original question.

 

[RussChilds]

Thats it - thanks!!!!!!!!!!!!