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.
- 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.