I have several data in a row, different from the column.
Ex: A, B
Ex: C, D, E, F, G (...)
To merge me into a column Every 2 columns is required. Ex:
Column 1
A
C
E
G
Column 2
B
D
F
H
Thanks,
Assume that A
in A1, please copy in A2 and copy it to the bottom:
= OFFSET (A $ 1, 2 * (ROW () - 1) )
No comments:
Post a Comment