In D1 thru D9 enter:

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

--
Gary''s Student - gsnu2007d


"helena" wrote:

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