Fri 9 Feb 2007, 17:05Delegate Adam said...
Adam has attended:
Excel Intermediate course
Excel Advanced course
Data table, rotate
I have a table of data in excel that i effectively need to change to landscape. I need the column headings to instead be down the left handside and the left handside headings accress the top. Is there a quick way of doing this without re entering the data?
Mon 12 Feb 2007, 15:02Trainer Amanda said...
RE: data table, rotate
Hi Adam
Thanks for your question.
Luckily you don't need to re-enter all your data!
If you select and copy the data you wish to redisplay, then go to a new sheet and select the cell where you want the data to start from.
Go to Edit - Paste Special. Click the Transpose option down the bottom of the dialogue box and click OK.
This should turn columns into rows and rows into columns.
Amanda
