Several columns into one

[helena]

Hello all,

Is it possible to concatener by formula several columns into one ?
Example: initial data
A1: A3 = {1, 2, 3}
B1: B3 = {4, 5, 6}
C1: C3 = {7, 8, 9}
Result desired, D1: D9 = {1, 2, 3, 4, 5, 6, 7, 8, 9}

Thank you in advance for your suggestions,

Helena

 

[Gary''s Student]

In D1 thru D9 enter:

=A1
=A2
=A3
=B1
=B2
=B3
=C1
=C2
=C3

 

[David Biddulph]

=OFFSET($A$1,MOD(ROW()-1,3),INT((ROW()-1)/3))

 

[helena]

Thanks to both of you, particularly David who has fully answered that
question.


Thanks again ...

Helena