Hello all, first n00b post.

I am wishing to distribute numbers in 8 columns without any number repeating itself within the same column (for example, 32 is found in the first column seven times and I want it and all numbers to be distributed once into every column). It is imperative that the numbers do not move into a different row, but they may move within their own row. There are eight quantities of each number from 0 to 56.

What formula(s)/function(s) could I do in order to make this work?

Sample of what needs to be done:

49 1 2 3 4 5 6 0
7 49 9 10 11 12 13 8
15 14 49 16 17 18 19 20
23 21 22 49 24 25 26 27
32 33 34 28 49 29 30 31
35 36 37 38 39 49 41 40
42 43 44 45 46 47 49 48
0 35 7 42 14 50 21 28
1 36 8 43 15 50 22 29
2 37 9 44 16 50 23 30
3 38 10 45 17 50 24 31
32 4 39 11 50 46 18 25
33 5 40 12 47 50 19 26
34 6 41 13 48 50 20 27
0 32 48 8 16 40 51 24
1 33 41 42 17 51 9 25
34 35 10 43 2 18 51 26
51 3 36 11 44 19 27 28
4 37 12 45 51 20 21 29
5 38 13 14 51 46 22 30
6 39 7 15 51 23 47 31
0 38 9 47 18 52 27 29
1 39 10 48 19 52 21 30
2 40 42 11 20 22 52 31
32 3 41 43 12 14 52 23
33 35 4 44 13 15 52 24
34 36 5 7 45 16 52 25
37 6 8 46 17 52 26 28
0 33 36 10 46 20 53 23
1 34 37 11 14 47 53 24
2 38 12 15 48 53 25 28
3 39 42 13 16 53 26 29
4 7 40 43 17 53 27 30
5 8 41 44 18 21 53 31
32 35 6 9 45 19 53 22
0 41 11 45 15 54 26 30
1 35 12 46 16 54 27 31
32 2 36 13 47 17 21 54
33 3 37 7 48 18 22 54
34 4 38 8 42 19 54 23
5 39 9 43 20 54 24 28
6 40 10 44 14 54 25 29
0 34 39 44 12 17 22 55
1 40 55 13 45 18 23 28
2 7 41 46 19 55 24 29
3 8 47 35 20 55 25 30
4 9 14 48 55 36 26 31
32 37 10 15 55 27 42 5
33 43 38 6 11 16 21 55
0 37 43 13 19 56 25 31
32 1 38 7 44 20 56 26
33 2 39 8 45 14 56 27
34 3 40 9 46 15 21 56
4 41 10 47 16 22 56 28
35 5 11 48 17 23 56 29
36 6 42 12 56 18 24 30
56 50 51 52 53 54 55 49

Thanks in advance.