Have you tried using the pastespecial function "Transpose" ? It takes the selected rows and changes them to columns ... and visa/versa.