If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to the Columns area (or vice versa) in the PivotTable Field List. Verify these formulas use absolute references-if they don’t, you can switch between relative, absolute, and mixed references before you rotate the data. If your data includes formulas, Excel automatically updates them to match the new placement. Select the first cell where you want to paste the data, and on the Home tab, click the arrow. Using the Cut command or CONTROL+X won’t work. Note: Make sure you copy the data to do this. Īfter rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Here’s how: Select the range of data you want to rearrange, including any row or column labels, and either select Copy on the Home tab, or press CONTROL+C. For example, with some data in the range. Take any range of data you like to use that function.
Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. To change rows into columns, we can use the TRANSPOSE() function. The new table that you paste there will entirely overwrite any data / formatting that’s already there.
Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.Ĭhoose 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.
0 kommentar(er)
