Spreadsheet data all entered in a single column, imported from a document. How do I make that information appear in separate columns on a single row? In other words, how do I transpose a column to a row?
- 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.