Split a Range of data in Column A across subsequent columns

Closed
FetchItNow Posts 1 Registration date Friday November 21, 2014 Status Member Last seen November 21, 2014 - Nov 21, 2014 at 06:49 AM
Hi,

I have more than 1000 (it will go beyond 4000 somtimes) order numbers in column A that I would like to split across the subsequent columns starting from, say Column C by 13 numbers in each column. However, the first split should be 14 numbers and rest of the split should be 13 numbers. The split should effect until the last value in Column A.
I am giving an example with values ranges from 1 to 61.

Is that possible?


Columns
A B C D E F G
1 1 15 28 41 54
2 2 16 29 42 55
3 3 17 30 43 56
4 4 18 31 44 57
5 5 19 32 45 58
6 6 20 33 46 59
7 7 21 34 47 60
8 8 22 35 48 61
9 9 23 36 49
10 10 24 37 50
11 11 25 38 51
12 12 26 39 52
13 13 27 40 53
14 14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
.
.
.
.
.
.