Cómo transponer varias líneas en una sola columna
tobert0
Mensajes publicados
5
Estado
Miembro
-
JvDo Mensajes publicados 1924 Fecha de registro Estado Miembro Última intervención -
JvDo Mensajes publicados 1924 Fecha de registro Estado Miembro Última intervención -
Hello,
I would like to transpose several rows of 4 cells each into a single row.
example
A B C D
1 2 3 4
5 6 7 8
to give this:
E
1
2
3
4
5
....
of course the numbers are much more complex and so I would like to know if it is possible to transpose all the rows at once instead of one by one?
you would save a lot of time on copy-pasting
Configuration: Mac OS X (10.12.1) / Safari 10.0.1
I would like to transpose several rows of 4 cells each into a single row.
example
A B C D
1 2 3 4
5 6 7 8
to give this:
E
1
2
3
4
5
....
of course the numbers are much more complex and so I would like to know if it is possible to transpose all the rows at once instead of one by one?
you would save a lot of time on copy-pasting
Configuration: Mac OS X (10.12.1) / Safari 10.0.1
