convert matrix to a string

[Patrick Webb]

I want to convert a matrix array into a string column,
that is, convert the first row into a column string, then
the second row below the first and so on

 

[Max]

Assume you have a 5 x 5 matrix

Name this range: Tbl

Insert a new sheet

Enter the numbers 1 - 25 (ie: 5x5=25) down a column, say in A1:A25

In B1 put:
=OFFSET(Tbl,INT((A1-1)/COLUMNS(Tbl)),MOD(A1-1,COLUMNS(Tbl)),1,1)

Copy down B1:B25

B1:B25 should give you the desired arrangement/translation.

Adapt to suit.