Friday, 15 June 2012

Need to select every 2nd column excel -


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