Take multiple column'S values and APPEND 1 long consecutive column

[jcpreta]

take columns ABC and create a consecutive column D - just appending A TO B TO C
A B C D
---- ---- ---- ----
AAA BBB CCC AAA
Asia Asia Asia Asia
RED RED RED RED
DDD DDD DDD DDD
1BOL 1BOL 1BOL 1BOL
Merc Merc Merc Merc
---------------- BBB
---------------- Asia
---------------- RED
---------------- DDD
---------------- 1BOL
---------------- Merc
---------------- CCC
---------------- Asia
---------------- RED
---------------- DDD
---------------- 1BOL
---------------- Merc

[FDibbins]

You seem to be missing some values from your sample answer?

	A	B	C	D	E	F
2	AAA	BBB	CCC	AAA		AAA
3	Asia	Asia	Asia	Asia		BBB
4	RED	RED	RED	RED		CCC
5	DDD	DDD	DDD	DDD		Asia
6	1BOL	1BOL	1BOL	1BOL		Asia
7	Merc	Merc	Merc	Merc		Asia
8						RED
9						RED
10						RED
11						DDD
12						DDD
13						DDD
14						1BOL
15						1BOL
16						1BOL
17						Merc
18						Merc
19						Merc

F2=OFFSET($A$2,INT(ROW(A3)/3)-1,MOD(ROW(A2)-2,3))
copied down

[Tony Valko]

I think this is what they wanted...

Data Range

	A	B	C	D	E
1	------	------	------	------	------
2	1	7	13		1
3	2	8	14		2
4	3	9	15		3
5	4	10	16		4
6	5	11	17		5
7	6	12	18		6
8					7
9					8
10					9
11					10
12					11
13					12
14					13
15					14
16					15
17					16
18					17
19					18
20

This formula entered in E2 and copied down:

=OFFSET(A$2,MOD(ROWS(E$2:E2)-1,6),INT((ROWS(E$2:E2)-1)/6))