When you have data in rows and you
want to change the items in one of those rows into columns (or vice
versa). It would take a lot of time to copy and paste each individual
header -- but the transpose feature allows you to do is only one click your
data will move into columns.
Start by select the column that
you want to convert into rows, Right click and then select “Copy” next select
the cells on your sheet, where you want to your first Row to begin. Right click
on the cell and then select “Paste Special” a Pop Up window will appear and at
the bottom, you will see a check box named “Transpose” check the box and select
OK. Your column will be converted to a Row or Vise Versa.