How to change an arrangement

[Oleg]

How to change an arrangement /rows to columns, columns to rows/ on Shee
1 to Sheet 2.

Example in attachmen

Attachment filename: exmpl.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=49083

 

[Hakan Gök]

Select and copy wanted range
Right click to mouse
Select " Paste Special"
Select "Transverse"

I hope result is as you wanted

regards,