Excel - Convert a row into a column and vice-versa

December 2016

It may happens that you need to convert a row into a column or vice-versa, under Excel. That is: transfering all the cells from an horizontal display to a vertical one or otherwise. Here's a small trick:
  • Select the targeted cells.
  • Do a CTRL+C to copy them.
  • Move to the first cell of your new row/column (Note that this cell must be outside the copy area).
  • Right click> Paste Special.
  • Check the "Transpose" option and click on OK.

Here's the result:

Related :

This document entitled « Excel - Convert a row into a column and vice-versa » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.