Several columns into one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

helena - 10 Feb 2008 17:26 GMT

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

Reply to this Message

Gary''s Student - 10 Feb 2008 17:39 GMT

In D1 thru D9 enter:

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

Signature

Gary''s Student - gsnu2007d

> Hello all,
>
[quoted text clipped - 8 lines]
>
> Helena

Reply to this Message

David Biddulph - 10 Feb 2008 18:33 GMT

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

Signature

David Biddulph

> Hello all,
>
[quoted text clipped - 8 lines]
>
> Helena

Reply to this Message

helena - 10 Feb 2008 18:48 GMT

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

Thanks again ...

Helena

> =OFFSET($A$1,MOD(ROW()-1,3),INT((ROW()-1)/3))
>> Hello all,
[quoted text clipped - 9 lines]
>>
>> Helena

Reply to this Message