Zig Zag Extraction of Data

	A	B	C	D	E
1	Apple	Banana	Cherry		=A1
2	Durant	Elderberry	Fig		=B1
3	Goji	Honeydew	Jambul		=C1
4					=A2
5					=B2
6					=C2
7					=A3
8					=B3
9					=C3

	A	B	C	D	E
1	Apple	Banana	Cherry		Apple
2	Durant	Elderberry	Fig		Banana
3	Goji	Honeydew	Jambul		Cherry
4					Durant
5					Elderberry
6					Fig
7					Goji
8					Honeydew
9					Jambi

The output from the top table would show as the bottom table. I am manually entering the [=] functions in column E but it gets labor intensive when my fruit list goes on indefinitely in it's zig zag pattern (right for three columns, then jump to next row, right for three columns, then jump to next row, rinse, wash, repeat).

How can I write a better formula in column E? I want a formula I can paste down for hundreds of rows that will pull data in the zig zag fashion described above.

PS - Bonus question. I read Chandoo and Peltier all the time - excellent blogs. Are there other similar awesome Excel blogs like theirs that are fun and entertaining? I pretty much read all their posts and need some new material to expand my horizons. Darkhorse analytics is interesting but there are only about five posts on that site.

Row\Col	A	B	C	D	E	F
1	Apple	Banana	Cherry		Apple	E1: =INDEX($A$1:$C$3, INT((ROWS(E$1:E1) - 1) / COLUMNS($A$1:$C$3)) + 1, MOD(ROWS(E$1:E1)-1, COLUMNS($A$1:$C$3)) + 1)
2	Durant	Elderberry	Fig		Banana
3	Goji	Honeydew	Jambul		Cherry
4					Durant
5					Elderberry
6					Fig
7					Goji
8					Honeydew
9					Jambul

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.