Next, select the entire range that you want to transpose. This means that each column should indicate a month and each row should belong to a particular product name. In the example below, we want to transpose the range A1:E13. 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. Follow these steps to start using the Paste Transpose option: First, identify which range you would like to transpose. 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. Īfter rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Is there an easy way to rotate it 90 degrees i though i could just drag the row field to column field and vice versa- but it takes some of the formatting off. i need to chane it so that the projects are rows and the months are columns. Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. I have a pivot table with projects across the columns and months down the rows. Go to the first cell in the destination block, click the arrow beside Paste, and choose. You can do this by clicking and dragging your mouse over the cells you want. The new table that you paste there will entirely overwrite any data / formatting that’s already there. Flip Columns And Rows Select the block of data and choose Copy. I have a 384x32 matrix and I would like to transpose it so that the row is a column corresponding to the values on the row for example: original table. To transpose data in Excel, you first need to select the data you want to transpose. 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 Comments
Leave a Reply. |