TRANSPOSE

Formulas / TRANSPOSE
Flip the orientation of a range of cells.
==TRANSPOSE(array)
  • array - a range of cells

Examples

  • =TRANSPOSE(A1:A5)

    The first example uses the TRANSPOSE function to convert a range of cells from a vertical to a horizontal orientation. For example, this will convert the range A1:A5 from a vertical to a horizontal orientation.

  • =TRANSPOSE(A1:E1)

    The second example uses the TRANSPOSE function to convert a range of cells from a horizontal to a vertical orientation. For example, this will convert the range A1:E1 from a horizontal to a vertical orientation.

  • =TRANSPOSE({"a";"b";"c"})

    The third example uses the TRANSPOSE function to convert an array of values from a vertical to a horizontal orientation. For example, this will convert the array {"a";"b";"c"} from a vertical to a horizontal orientation and return the result as {"a","b","c"}.


Summary

The TRANSPOSE function quickly and easily changes a vertical range of cells into a horizontal range. It is a useful tool for re-arranging data in Sourcetable.

  • The TRANSPOSE function is dynamic and updates whenever data in the source range changes.
  • The TRANSPOSE function can be used with both ranges and arrays to swap the orientation of them.

Frequently Asked Questions

What is the TRANSPOSE function?
The TRANSPOSE function is a function in Sourcetable that flips the orientation of a range or array. It can be used with both ranges and arrays and returns an array in a new direction.
How does the TRANSPOSE function work?
The TRANSPOSE function works by taking the first row and turning it into the first column of the new array, the second row becomes the second column of the new array, the third row becomes the third column of the new array, and so on. The TRANSPOSE function updates whenever the source data changes.
What is the benefit of using the TRANSPOSE function?
The main benefit of using the TRANSPOSE function is that it quickly and easily flips the orientation of a range or array. This can be useful for quickly changing the orientation of a dataset or array without needing to manually change the data.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV