how do I transpose information in a spreadsheet column to a row?

edit

• Select your column of data and copy it;
• right-click in the cell where you want to start the row;
• select Paste Special > Paste Special... which should bring up this dialog:

• make sure the [✓] Transpose check box is ticked under Options,
• click OK.

Your column of data will now be a row.