You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns. If your data is in an Excel table, the Transpose feature won’t be available. Verify these formulas use absolute references-if they don’t, you can switch between relative and absolute references before you rotate the data. If your data includes formulas, Excel automatically updates them to match the new placement. The data you copied will overwrite any data that’s already there.Īfter rotating the data successfully, you can delete the original data. Pick a spot in the worksheet that has enough room to paste your data. Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose. Using the Cut command or CONTROL+X won’t work. Note: Make sure you copy the data to do this.
