When you have low rows of data in your spreadsheet, you might decide you actually want to transform 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 what the transpose feature allows you to do is simply move your row data into columns, or the other way around.
Start by highlighting the column that you want to transpose into rows. Right-click it, and then select "Copy." Next, select the cells on your spreadsheet where you want your first row or column to begin. Right-click on the cell, and then select "Paste Special." A module will appear -- at the bottom, you'll see an option to transpose. Check that box and select OK. Your column will now be transferred to a row or vice-versa.