The TRANSPOSE function in Google Sheets is a versatile tool that allows users to interchange the rows and columns of a given array or range of cells. This can be particularly useful for data analysis, presentation, and organizing data in a more comprehensible manner. By using this function, users can manipulate their datasets efficiently, ensuring that the information is displayed in a way that is best suited for their needs.
Syntax
TRANSPOSE(array)
- array: The range of cells or array to be transposed. This is the only required parameter for the function.
Example #1
TRANSPOSE(A1:B2)
This function switches the rows and columns of the specified range A1:B2. If A1 contains “Name” and A2 contains “John”, while B1 holds “Age” and B2 has “30”, the output will be:Name Age
John 30
Example #2
TRANSPOSE(C3:E5)
By applying this function to the range C3:E5, where C3 contains “Product”, C4 contains “A”, C5 contains “B”, D3 contains “Price”, D4 contains “10”, and D5 holds “20”, the result will be:Product A B
Price 10 20
Example #3
TRANSPOSE(F1:F3)
Using this command on a single-column range F1:F3, consisting of the values “X”, “Y”, and “Z”, transforms it into a single-row array:X Y Z
Error handling
- VALUE! – This error occurs if the specified array is not valid, such as if it references non-existent ranges.
- REF! – This error indicates that the referenced range has been deleted or is invalid.
- N/A – This error may arise when trying to transpose an empty range, indicating that no data is available to perform the operation.