1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel TRANSPOSE Function

Transpose Rows to Columns in Excel

By

Excel TRANSPOSE Function

Excel TRANSPOSE Function

© Ted French

The TRANSPOSE function is used to copy data located in a row into a column or copy data located in a column into a row.

The syntax for the TRANSPOSE function is:

{ = TRANSPOSE ( Array )}

Array - the range of cells to be copied from a row into a column or from a column into a row.

The curly braces " { } " surrounding the function indicate that it is an array formula.

Example: Transpose Rows to Columns in Excel

For help with this example, see the image above.

  1. Enter the following data into cells:
    B1 - cabbages , B2 - carrots, B3 - radishes

  2. Drag select cells D1 to F1 - the location where the results will be displayed.

  3. Click on the Formulas tab.

  4. Choose Lookup & Reference functions > TRANSPOSE from the ribbon to open the function's dialog box.

  5. Drag select cells B1 to B3 on the worksheet.

  6. Press the CTRL , SHIFT , and ENTER keys on the keyboard at the same time to enter the function as an array function.

  7. The data in cells B1 to B3 should appear in cells D1, E1, and F1.

  8. When you click on any of the cells D1 to F1 the complete function
    { = TRANSPOSE ( B1 : B3 )} appears in the formula bar above the worksheet.

Other Excel Lookup Functions

©2014 About.com. All rights reserved.