Need fomula

Hi,

Please help me on the formula to to copy the contents of column A and column B to column C in interval.

ex.
Column A contains

A1
A2
A3
A4

Column B contains
B1
B2
B3
B4

Column C should contains
A1
B1
A2
B2
A3
B3
A4
B4

Thanks.

Originally Posted by kenzo

Hi,

Please help me on the formula to to copy the contents of column A and column B to column C in interval.

ex.
Column A contains

A1
A2
A3
A4

Column B contains
B1
B2
B3
B4

Column C should contains
A1
B1
A2
B2
A3
B3
A4
B4

Thanks.

Try this:
=OFFSET($A$1,INT((ROWS($A$1:A1)-1)/2),MOD(ROWS($A$1:A1)-1,2))

Thanks a lot. The formula works perfectly.

I would create a macro that copys content from A and B columns to C column and then sort according to your criteria.........