Row with many cells to 2 columns!

[Niklas]

Hi!

I have a row with many cells and would like to make 2 columns this way:

From:
A1 A2 A3 A4 A5 A6 A7 A8 A9 A10

To:

A1 A2
A3 A4
A5 A6
A7 A8
A9 A10

I guess this is possible with TRANSPOSE but I cant figure out what kind of arguments to use.

Can someone please help me, I'll be more than happy

Cheers!
/Niklas

[zbor]

Try this in B1 and pull down and right:

=INDEX($A:$A, 2*ROWS($A$1:A1)-COLUMNS($A$1:A1))

[Niklas]

Thanks!

But Im was so tired when I posted this

I ment

From values in cells:

A1 B1 C1 D1 E1 F1 G1 H1 I1 J1

To:

A1 B1
C1 D1
E1 F1
G1 H1
I1 J1

Is this possible with that INDEX thing?

/Niklas

[zbor]

Just replace INDEX array, put in some other row (i.e.B2) and pull down:

(also I've slightly improve it):

=INDEX($1:$1, 2*ROWS($A$1:A1)+COLUMNS($A$1:A1)-2)

[Niklas]

Works soo perfect!!!!!

Thanks a bunch ZBOR, you saved me a lot of work!


Cheers
/Niklas