1.Copy the cells in row select the same number of cells in row and paste
2.Copy the cells in column then choose Edit >> Paste Special then click Transpose and OK
3.Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
4.Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special mark Transpose check box and click OK.