Flip the orientation of a range of cells.

`=TRANSPOSE(array)`

- array - a range of cells

`=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"}.

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.

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.

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.

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.

Drop CSV