How To: Excel Transpose Row To Column

By

In this quick tutorial, we will se how to transpose a row to a column in Excel. This trick is pretty useful if you started typing data into a row, but later realized that you, in fact need that data in a column rather than in row.

How To Transpose Row To Column In Excel

Transpose is a function that allow you to transpose rows to columns in Excel. The data of your row will be converted into a vertical form in Microsoft Excel.

Follow the steps below in Excel to transpose rows to columns:

  • Select the rows you want to transpose into columns
  • Copy the rows you have selected by right-clicking with your mouse and clicking on Copy.
  • Left-click on the first cell where you want to paste your data
  • Click on the little arrow next to the Paste button’s icon
  • Click on Paste Transpose

After pasting using Paste transpose, the row you have selected will be transposed to rows starting from the cell you have choosed

How To Transpose Row To Column In Older Versions Of Excel

On older version of Office like Office 2007 or Office 2013, the procedure to transpoe row to columns in excel is pretty similar although there is not a ready-made button to transpose row to columns.

Follow the steps below in older versions of Excel to transpose rows to columns:

  1. Select the rows you want to transpose into columns
  2. Copy the rows you have selected by right-clicking with your mouse and clicking on Copy.
  3. Left-click on the first cell where you want to paste your data
  4. Click on Paste Special
  5. Click on Transpose
  6. Click on OK

After clicking on OK, Excel will transpose the rows to columns.

Related Posts

Leave a Comment