Office Expert

Transpose Columns And Rows 

You can quickly turn column labels into row labels or row labels into column labels using the Transpose command.

For example, you might create a worksheet to include three column labels and three row labels but later decide it is better the other way around. Rather than retype the text, you can activate the Transpose command.

Steps

1.Select the cells you want to transpose 

2.Copy the selected cells

3.Click where you want to insert the transposed text.

4.Click on Paste Menu & Click on Transpose 

5.We will get the below transposed text in the selected location .