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