A feature that converts vertical data ranges into horizontal ones, and vice versa.
Mit KI ausprobierenTransposing changes the orientation of a data range by swapping its rows and columns. This is useful for reformatting tables to better fit a report layout or for preparing data for specific analysis tools.
=TRANSPOSE(array)If you have a list of names in one column, transposing them will place those names across a single row.
If you use the TRANSPOSE function, it updates automatically; if you use Paste Special, it creates a static copy.