Split a Range of data in Column A across subsequent columns [Closed]

Report
Posts
1
Registration date
Friday November 21, 2014
Status
Member
Last seen
November 21, 2014
-
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
.
.
.
.
.
.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!