Several columns into one
 

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

Several columns into one
 

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

Several columns into one
 

=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

Several columns into one
 

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