The transposition won't work correctly unless the two areas fall in completely separate parts of your worksheet. Don't overlap the worksheet area from which you copy your data with the one to which you paste it.This procedure accomplishes the same result as accessing the Transpose command from the ribbon.
![how to copy and transpose in excel troubleshooting how to copy and transpose in excel troubleshooting](https://cdn.extendoffice.com/images/stories/doc-excel/stack-columns-left-to-right/doc-stack-columns-left-to-right-10.png)
Choose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data. Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.
![how to copy and transpose in excel troubleshooting how to copy and transpose in excel troubleshooting](https://cdn.extendoffice.com/images/stories/doc-excel/horizontal-to-vertical/doc-horizontal-to-vertical-13.png)
![how to copy and transpose in excel troubleshooting how to copy and transpose in excel troubleshooting](https://www.thewindowsclub.com/wp-content/uploads/2013/01/paste-special.png)
Highlight the range you want to transpose. Step 2: Copy And Paste Transpose Highlight and copy the range which you want to transpose. In an absolute reference, you'll see a "$" in front of each portion of the reference notation. Replace any formula with text in the range which you want to transpose. Functions and formulas that rely on absolute references to specific cells will fail to calculate correctly after you transpose your data, if those references point to cells in the area you transpose and not to cells elsewhere in your worksheet.