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.