Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

As it happens, this is quite easily done:

  1. Select the area of data you want to "convert", e.g., click top-left cell, then shift-click bottom right cell. You should how have copied all the rows of data that you want to convert into columns of data.
  2. Hit CTRL-C to copy.
  3. Go to a new worksheet, click the cell where you want to paste your new columns.
  4. Either hit Shift-CTRL-V, or use Edit > Paste Special... from the toolbar to bring up this dialog:
    Paste special
  5. Ensure that the Transpose option is selected, then click OK. Done!

The same process works in either direction (cols-to-rows, rows-to-cols).


I couldn't find this on AskLibo, and have followed these Excel instructions.

As it happens, this is quite easily done:

  1. Select the area of data you want to "convert", e.g., click top-left cell, then shift-click bottom right cell. You should how have copied all the rows of data that you want to convert into columns of data.
  2. Hit CTRL-C to copy.
  3. Go to a new worksheet, click the cell where you want to paste your new columns.
  4. Either hit Shift-CTRL-V, or use Edit > Paste Special... from the toolbar to bring up this dialog:
    Paste special
  5. Ensure that the Transpose option is selected, then click OK. Done!

The same process works in either direction (cols-to-rows, rows-to-cols).


Credit: I couldn't find this on AskLibo, and have followed these Excel instructions.