TRANSPOSE
Formulas / TRANSPOSEFlip 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?
How does the TRANSPOSE function work?
What is the benefit of using the TRANSPOSE function?
