spliting a matrix in 1 column

[Marc Bonnet]

I have a matrix that I need to align in one single column,
(column 1 first, then column 2 beside it, ...)
Is there any function to do that ?
TIA
MB-orage

 

[Andy Brown]

Is there any function to do that ?

Well, there's stuff you can do with formulas. Say you have data in A14. In
F1, enter

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

and drag down to F16.

For 5 x 5, you'd just use

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

HTH,
Andy

 

[Alan Beban]

See my reply in this newsgroup this morning to "How to Transpose a table
to a single column" by king_jeremy.

Alan Beban