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

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

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

"helena" wrote in message
...
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

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


Thanks again ...

Helena


"David Biddulph" <groups [at] biddulph.org.uk a écrit dans le message de
news: ...
=OFFSET($A$1,MOD(ROW()-1,3),INT((ROW()-1)/3))
--
David Biddulph

"helena" wrote in message
...
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