Excel Function Transpose – Transfer column Vertical data to Row in Horizontal Form and Row’s Horizontal data to column in Vertical Form

by

Transfer data from column to row and row data to column with Transpose Excel Function

What is Transpose Excel Function?

The list that is in the column, we can copy and paste it in Horizontal form in Row. And Row’s Horizontal data can be transferred to Vertical Form in a list.

Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form

How to use MS Excel Function Transpose Excel Function ?

1. Transfer column data to Row –

There are 3 ways to use Paste Special.
Method 1. Select and copy the data of the column. 
Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form
Click on the One cell in the row in which to paste the data. Right click with the mouse. Move the mouse Cursor on the option of paste special. More options of Paste Special will appear in the side window.
Click on this symbol of Transpose All the data will be pasted in RAW.
Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form
Method 2. Select and copy the data of the column. Click on the One cell in the row in which to paste the data. By clicking on the drop down button of the paste option in the Home tab, the window of the paste special will open. 
Click on thissymbol of Transpose. All data will be pasted into Row.
Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form
Method 3. Select and copy the data of the column. Click on the One cell in the row in which to paste the data.

 Press Ctrl + Alt + V Use this shortcut key. The paste special window will open. Click on the Transpose option and click on OK. Data will be transferred.

Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form
Or by right clicking on the mouse, the Paste special window will also open from here.
Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form
clicking on Paste Special will open the window.


 Or click on Paste Special from the drop down of paste option in the Home tab.
Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form


2. Transfer Row data to Column –

Just as the data of the column was transferred to Row, select Row’s data and copy it. You can transpose the data Horizontally in the three ways mentioned above by clicking on the first cell of the column where you want to paste.
Ctrl + Alt + V >> Transpose

Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form
Similarly, we can select and transpose multiple columns.
Excel Functions Transpose - Transfer column Horizontal data to Row in Vertical Form and Row's Vertical data to column in Horizontal Form

Leave a Comment