Transposing or converting data in a row to column in MS EXCEL

STEPS:

1) Copy the Row to be transposed

2) Go to an Empty row

3) Right Click Mouse-> Paste Special

4) Select Values in Paste options

5)Tick Transpose option in Operations.

6) Clock Ok

7) Task is accomplished