Spreadsheet: 871178d1717585447-splitting-columns-into-multiple-cctest
Sheet: CCSpend

Index | Cost Centre | Spend |  |  |  | Index | Cost Centre | Spend |  | Index | Cost Centre | Spend |  | Index | Cost Centre | Spend
1 | CC00001 | 351.6331 |  | Need this <-- to end up like this --> |  | 1 | CC00001 | 351.6331 |  | 31 | CC00031 | 455.8555 |  | 61 | CC00061 | 692.7494
2 | CC00002 | 338.824 |  |  |  | 2 | CC00002 | 338.824 |  | 32 | CC00032 | 410.2513 |  | 62 | CC00062 | 515.9762
3 | CC00003 | 511.5401 |  |  |  | 3 | CC00003 | 511.5401 |  | 33 | CC00033 | 259.5526 |  | 63 | CC00063 | 332.5641
4 | CC00004 | 563.4368 |  |  |  | 4 | CC00004 | 563.4368 |  | 34 | CC00034 | 461.2044 |  | 64 | CC00064 | 129.0512
5 | CC00005 | 875.4404 |  |  |  | 5 | CC00005 | 875.4404 |  | 35 | CC00035 | 976.168 |  | 65 | CC00065 | 737.5604
6 | CC00006 | 162.3569 |  |  |  | 6 | CC00006 | 162.3569 |  | 36 | CC00036 | 639.2695 |  | 66 | CC00066 | 724.0837
7 | CC00007 | 473.6586 |  |  |  | 7 | CC00007 | 473.6586 |  | 37 | CC00037 | 291.7214 |  | 67 | CC00067 | 343.7865
8 | CC00008 | 877.5081 |  |  |  | 8 | CC00008 | 877.5081 |  | 38 | CC00038 | 751.4144 |  | 68 | CC00068 | 829.5265
9 | CC00009 | 248.2481 |  |  |  | 9 | CC00009 | 248.2481 |  | 39 | CC00039 | 565.5922 |  | 69 | CC00069 | 670.6268
10 | [NAME] | 646.3584 |  |  |  | 10 | [NAME] | 646.3584 |  | 40 | CC00040 | 669.2514 |  | 70 | CC00070 | 463.9958
11 | CC00011 | 38.8488 |  |  |  | 11 | CC00011 | 38.8488 |  | 41 | CC00041 | 46.2621 |  | 71 | CC00071 | 212.0787
12 | CC00012 | 388.286 |  |  |  | 12 | CC00012 | 388.286 |  | 42 | CC00042 | 52.9365 |  | 72 | CC00072 | 346.2946
13 | CC00013 | 85.766 |  |  |  | 13 | CC00013 | 85.766 |  | 43 | CC00043 | 554.2177 |  | 73 | CC00073 | 850.4067
14 | CC00014 | 357.9898 |  |  |  | 14 | CC00014 | 357.9898 |  | 44 | CC00044 | 644.4342 |  | 74 | CC00074 | 333.3756
15 | CC00015 | 217.0372 |  |  |  | 15 | CC00015 | 217.0372 |  | 45 | CC00045 | 860.7579 |  | 75 | CC00075 | 848.5071
16 | CC00016 | 88.3918 |  |  |  | 16 | CC00016 | 88.3918 |  | 46 | CC00046 | 432.9573 |  | 76 | CC00076 | 709.5304
17 | CC00017 | 318.1832 |  |  |  | 17 | CC00017 | 318.1832 |  | 47 | CC00047 | 890.7977 |  | 77 | CC00077 | 861.0136
18 | CC00018 | 164.4154 |  |  |  | 18 | CC00018 | 164.4154 |  | 48 | CC00048 | 251.0394 |  | 78 | CC00078 | 569.1975
19 | CC00019 | 593.4488 |  |  |  | 19 | CC00019 | 593.4488 |  | 49 | CC00049 | 799.409 |  | 79 | CC00079 | 317.9268
20 | CC00020 | 589.1383 |  |  |  | 20 | CC00020 | 589.1383 |  | 50 | CC00050 | 353.6073 |  | 80 | CC00080 | 212.1019
21 | CC00021 | 46.8553 |  |  |  | 21 | CC00021 | 46.8553 |  | 51 | CC00051 | 632.2541
22 | CC00022 | 418.8681 |  |  |  | 22 | CC00022 | 418.8681 |  | 52 | CC00052 | 758.3226
23 | CC00023 | 239.1357 |  |  |  | 23 | CC00023 | 239.1357 |  | 53 | CC00053 | 3.3761
24 | CC00024 | 255.5476 |  |  |  | 24 | CC00024 | 255.5476 |  | 54 | CC00054 | 496.3789
25 | CC00025 | 258.0712 |  |  |  | 25 | CC00025 | 258.0712 |  | 55 | CC00055 | 916.4276
26 | CC00026 | 288.4695 |  |  |  | 26 | CC00026 | 288.4695 |  | 56 | CC00056 | 777.1802
27 | CC00027 | 827.1549 |  |  |  | 27 | CC00027 | 827.1549 |  | 57 | CC00057 | 109.0961
28 | CC00028 | 143.4624 |  |  |  | 28 | CC00028 | 143.4624 |  | 58 | CC00058 | 805.8108
29 | CC00029 | 115.257 |  |  |  | 29 | CC00029 | 115.257 |  | 59 | CC00059 | 618.7242
30 | CC00030 | 684.3929 |  |  |  | 30 | CC00030 | 684.3929 |  | 60 | CC00060 | 776.6509
31 | CC00031 | 455.8555
32 | CC00032 | 410.2513
33 | CC00033 | 259.5526
34 | CC00034 | 461.2044
35 | CC00035 | 976.168
36 | CC00036 | 639.2695
37 | CC00037 | 291.7214
38 | CC00038 | 751.4144
39 | CC00039 | 565.5922
40 | CC00040 | 669.2514
41 | CC00041 | 46.2621
42 | CC00042 | 52.9365
43 | CC00043 | 554.2177
44 | CC00044 | 644.4342
45 | CC00045 | 860.7579
46 | CC00046 | 432.9573
47 | CC00047 | 890.7977
48 | CC00048 | 251.0394
49 | CC00049 | 799.409
50 | CC00050 | 353.6073
51 | CC00051 | 632.2541
52 | CC00052 | 758.3226
53 | CC00053 | 3.3761
54 | CC00054 | 496.3789
55 | CC00055 | 916.4276
56 | CC00056 | 777.1802
57 | CC00057 | 109.0961
58 | CC00058 | 805.8108
59 | CC00059 | 618.7242
60 | CC00060 | 776.6509
61 | CC00061 | 692.7494
62 | CC00062 | 515.9762
63 | CC00063 | 332.5641
64 | CC00064 | 129.0512
65 | CC00065 | 737.5604
66 | CC00066 | 724.0837
67 | CC00067 | 343.7865
68 | CC00068 | 829.5265
69 | CC00069 | 670.6268
70 | CC00070 | 463.9958
71 | CC00071 | 212.0787
72 | CC00072 | 346.2946
73 | CC00073 | 850.4067
74 | CC00074 | 333.3756
75 | CC00075 | 848.5071
76 | CC00076 | 709.5304
77 | CC00077 | 861.0136
78 | CC00078 | 569.1975
79 | CC00079 | 317.9268
80 | CC00080 | 212.1019