The transpose function is purely handy as well as versatile. Using the transpose function let your data change its orientation such as the vertical range of your columns’ orientation and the horizontal range of your rows’ orientation. In Excel, you can use multiple methods for Excel flip rows and columns.īefore diving into the explanation of methods, let’s have a look at what is Transpose function used in Excel.

In this case, you will have to transpose Excel data to accommodate your preference. For instance, if an Excel spreadsheet has data in horizontal cells, it might be possible that your boss prefers that data to be flipped vertically. Converting column data into rows and rows’ data into columns merely requires you to follow simple steps. Having data in rows might be sometimes needed to flip into columns or vice versa. 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.As you know that people look at Excel data in their own way. 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. Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. 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.

Turn columns into rows