Interlase numbers.

[serge]

Hello everyone,

I'm looking for a formula that will interlace 2 columns numbers together.
I have numbers in column B and C and would like to interlace them together in column D.
See example bellow, Thank you.

 

[KRice]

Perhaps something like this:

Book1
	B	C	D
3	Col1	Col2	Mix
4	a	n	a
5	b	o	n
6	c	p	b
7	d	q	o
8			c
9			p
10			d
11			q
12
Sheet1

Cell Formulas
Range	Formula
D4:D12	D4	=IFERROR(INDEX($B$4:$C$7,INT((ROWS(D$4:D4)-1)/2)+1,MOD(ROWS(D$4:D4)-1,2)+1),"")

 

[serge]

Hi KRice, Thank you for the formula it works very well, really appreciate it.

 

[KRice]

You're welcome...I'm happy to help.