Using the TRANSPOSE Function

Contact Us or call 1-877-932-8228
Using the TRANSPOSE Function

Using the TRANSPOSE Function

You can use the TRANSPOSE function to return a horizontal range of cells as a vertical range or a vertical range as a horizontal range.

To use TRANSPOSE, you must know the array, the range of cells you want to transpose and also preselect the new location (making sure the number of cells match). To use the TRANSPOSE function:

  1. Pre-select the new location, being mindful that the number of cells matches.
  2. On the FORMULAS tab, in the Function Library group, click the Insert Function command:
  3. In the Insert Function dialog box:
    1. Search on "TRANSPOSE" or, in the Or select a category drop-down box, select Recommended.
    2. Under Select a function, select TRANSPOSE.
    3. Click OK.
  4. In the Function Arguments dialog box:
    1. In the Array data entry field, enter the range of cells or an array of values you want to transpose.
    2. You must then press the following keyboard keys to turn this into an array: CTRL + SHIFT+ ENTER.
    3. Click OK.
Next