Combine columns into one column

[Naruto]

Hi, I want to combine columns of data into one, e.g.
to combine column 1, 2 and 3 into column 4 (excel prof. edition 2003)

column 1 column 2 column 3 column 4
1 a i 1
2 b ii a
3 c iii i
4 d iv 2
5 e v b
6 f vi ii
7 g vii 3
....

Thanks in advance.

 

[Roger Govier]

Hi

One way
In cell D1 enter
=INDEX(A:C,INT((ROW()-1)/3)+1,MOD(ROW()-1,3)+1)
Copy down as far as required

 

[Naruto]

Hi, thanks for the reply.
I need some time to understand the formula and to modify it to suit my real
situation.

 

[JP]

What do you mean by "combine" ?

=A1&B1&C1 or =A1&","&B1&","&C1

will concatenate the cells into one cell (optionally with a comma
between)

=A1+B1+C1 or =SUM(A1:C1)

will add the values in each cell together.

If you have text and values mixed together in one row, you will want
the first option.


HTH,

JP

 

[Alan Beban]

Hi, I want to combine columns of data into one, e.g.
to combine column 1, 2 and 3 into column 4 (excel prof. edition 2003)

column 1 column 2 column 3 column 4
1 a i 1
2 b ii a
3 c iii i
4 d iv 2
5 e v b
6 f vi ii
7 g vii 3
...

Thanks in advance.

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=ArrayReshape(a1:c7,COUNTA(a1:c7,1)) array entered.

Alan Beban