spliting a matrix in 1 column

  • Thread starter Thread starter Marc Bonnet
  • Start date Start date
M

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
 
Is there any function to do that ?

Well, there's stuff you can do with formulas. Say you have data in A1:D4. 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
 
See my reply in this newsgroup this morning to "How to Transpose a table
to a single column" by king_jeremy.

Alan Beban
 
Back
Top