swap rows and colums

  • Thread starter Thread starter jkegholm
  • Start date Start date
J

jkegholm

Hi!

My sister has made a large sheet, but for the prosessing I need to swa
the rows into colums and vice versa.

How can I "rotate" the data 90 degrees??

(I am really in a hurry - her assignment is due within few days.)

THANK
 
Select the range
Edit|copy
select a cell not in that range
Edit|paste special|click Transpose.

You are limited to transposing 256 rows/columns (you run out of columns
quickly).
 
Select Range
Copy Then
Move Pointer to a target-cell (for the destination)
and Right Click > Short cut menu > Paste Special >> Check (ON) 'Transpose
Checkbox
Click OK-Button
Click to expand...
Good Luck!
 
Back
Top