Help Menu

Transpose in Place

The Transpose in Place tool allows you to transpose a selection in place without resorting to Copy and Paste Special with the Transpose option, and then having to delete the original content.

Notes

  • For non-square ranges (different number of rows and columns), this will overwrite any content in cells the fall within the resulting output range.
  • This tool autosaves the workbook prior to the transpose operation. If you want to revert back to the previous state, use the Close and Re-Open Workbook tool.