How to transpose multiple rows into a single column
tobert0
Posted messages
5
Status
Member
-
JvDo Posted messages 1924 Registration date Status Member Last intervention -
JvDo Posted messages 1924 Registration date Status Member Last intervention -
Bonjour,
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 complicated, so I would like to know if it is possible to transpose all the rows at once and not one by one?
You would save a lot of copy-pasting hours.
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 complicated, so I would like to know if it is possible to transpose all the rows at once and not one by one?
You would save a lot of copy-pasting hours.
Configuration: Mac OS X (10.12.1) / Safari 10.0.1
