Converts a vertical range of cells into a horizontal range, or vice versa.
Syntaxe
TRANSPOSE(array)Arguments
arrayobligatoire
The array or range of cells on your worksheet that you want to transpose.
The TRANSPOSE function flips the orientation of an array or range of cells. It is a dynamic array function that automatically spills the results into the required number of cells.
=TRANSPOSE(A1:A3)→B1:D1Converts a column range A1:A3 into a row range starting at B1.
Select the target cell
Click on the cell where you want the transposed data to begin.
Enter the formula
Type =TRANSPOSE( followed by the range you want to flip, then close the parenthesis.
Press Enter
Press Enter to execute the function and see the spilled results.
Yes, as a dynamic array function, it updates automatically when the source data changes.