Transpose

Transpose Function    |   Paste Special Transpose

The Transpose function in Excel switches rows to columns or columns to rows. You can also use the 'Paste Special Transpose' option to transpose data.

Transpose Function

To insert the Transpose function, execute the following steps.

1. First, select the new range of cells.

2. Type in =TRANSPOSE(

3. Select the range A1:C1 and close with a parenthesis.

4. Finish by pressing CTRL + SHIFT + ENTER.

Note: The formula bar indicates that this is an array formula by enclosing it in curly braces {}. To delete this array formula, select the range E2:E4 and press Delete.

Paste Special Transpose

You can also use the 'Paste Special Transpose' option to transpose data.

1. Select the range A1:C1.

2. Right click, and then click Copy.

3. Select cell E2.

4. Right click, and then click Paste Special...

5. Check Transpose.

6. Click OK.

Did you find this information helpful? Please vote for us.

Go to Top: Transpose    |    Go to Next Example: Loans with Different Durations