Saturday, November 2

Transpose Data From Column to Row or Row to Column

To exchange or transpose or copy the data from Column to Row or Row to Column please follow the step mentioned below.

  • Transpose means to exchange the place of data.
  • Transpose to Row to Column means to copy the data from Row to Column (Header).
  • Transpose to Column to Row means to copy the data from Column (Header) to Row.
  • Select the data from where you want to transpose it. From COLUMN or ROW.
  • Then copy the selected data (Make sure the transpose range is same or the range is enough to paste it.
  • Make Sure there is no Merge Cells exist.
  • Select the cell where you want to paste the data.
  • Then right click and Click Paste Special.
  • One Dialog box will pop-up.
  • Down to the right bottom check the checkbox of TRANSPOSE and click Ok.
  • For more detail please check the image and video provided below.



Leave a Reply

Your email address will not be published. Required fields are marked *