If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook:

=ArrayReshape(A1:E3,15,1,"c") array entered into a 15-cell column.

Alan Beban

dgarg wrote:
I have data in form of array (table). For example:
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15

i want to convert this data into sigle column as below:
1
6
11
2
7
12
.
.
5
10
15

Can anyone suggest me the way to do this?