Use the option paste Special (Special Paste) > Transpose (Transpose) in Excel to convert rows to columns or columns to rows. You can also use the function TRANSPOSE (TRANSP).
Paste Special > Transpose
To transpose data, do the following:
- Select a range A1: C1.
- Right click and click Copy (Copy).
- Highlight a cell E2.
- Right click on it and then select paste Special (Special insert).
- Enable the option Transpose (Transpose).
- Press OK.
function TRANSP
To use the function TRANSPOSE (TRANSP), do the following:
- First, select a new range of cells.
- Enter the
= TRANSPOSE (
= ТРАНСП (
- Select a range A1: C1 and close the bracket.
- Finish entering the formula by pressing Ctrl + Shift + Enter.
Note: The formula bar indicates that this is an array formula because it is enclosed in curly braces {}. To remove this array formula, select the range E2: E4 and press the key Delete.