Hi
on your second sheet in A1 enter
=OFFSET('sheet1'!$A$1,INT((ROW()-1)/5),MOD(ROW()-1,5)
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany

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?