OOoES/Traduccion/Calc: Funcion TRANSPONER
From Apache OpenOffice Wiki
< OOoES
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
TRANSPONER
Transposición de la matriz. Intercambia las filas y columnas de una matriz.
Sintaxis:
TRANSPONER(Matriz)
- Donde Matriz es la que cuyas filas y columnas desea transponer.
Ejemplo:
| A | B | |
|---|---|---|
| 1 | 1 | 2 |
| 2 | 4 | 3 |
TRANSPONER(A1:B2)
- Devuelve
| C | D | |
|---|---|---|
| 21 | 1 | 4 |
| 22 | 2 | 3 |
Ejemplo: =TRANSPONER()
| A | B | |
|---|---|---|
| 1 | 12 | 121 |
| 2 | 13 | 14 |
| 3 | 114 | 15 |
| 4 | 115 | 16 |
Devuelve:
| E | F | G | H | |
|---|---|---|---|---|
| 1 | 12 | 13 | 114 | 115 |
| 2 | 121 | 14 | 15 | 16 |
