A
Copy the cells in row, select the same number of cells in row and paste
B
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
Option D:
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
No comments yet. Be the first to comment!