Spreadsheet: 871199d1717593966-splitting-columns-into-multiple-cctest
Sheet: CCSpend

Index | Cost Centre | Spend |  |  |  | Spend |  | Cost Centre | Spend |  | 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 --> | CC00001 | 351.6330551724935 |  | CC00031 | 455.8555308430435 |  | CC00061 | 692.7493923701421 |  |  |  |  |  | 1 | CC00001 | 351.6331 |  | 31 | CC00031 | 455.8555 |  | 61 | CC00061 | 692.7494
2 | CC00002 | 338.824 |  |  | CC00002 | 338.8240091561938 |  | CC00032 | 410.2513307836579 |  | CC00062 | 515.9761861979065 |  |  |  |  |  | 2 | CC00002 | 338.824 |  | 32 | CC00032 | 410.2513 |  | 62 | CC00062 | 515.9762
3 | CC00003 | 511.5401 |  |  | CC00003 | 511.5400532931842 |  | CC00033 | 259.5526031948548 |  | CC00063 | 332.5640541353394 |  |  |  |  |  | 3 | CC00003 | 511.5401 |  | 33 | CC00033 | 259.5526 |  | 63 | CC00063 | 332.5641
4 | CC00004 | 563.4368 |  |  | CC00004 | 563.4368337442885 |  | CC00034 | 461.2044048864697 |  | CC00064 | 129.0512103178758 |  |  |  |  |  | 4 | CC00004 | 563.4368 |  | 34 | CC00034 | 461.2044 |  | 64 | CC00064 | 129.0512
5 | CC00005 | 875.4404 |  |  | CC00005 | 875.4404104222041 |  | CC00035 | 976.1679937524557 |  | CC00065 | 737.5604133467737 |  |  |  |  |  | 5 | CC00005 | 875.4404 |  | 35 | CC00035 | 976.168 |  | 65 | CC00065 | 737.5604
6 | CC00006 | 162.3569 |  |  | CC00006 | 162.3569322943727 |  | CC00036 | 639.2694957925042 |  | CC00066 | 724.0836627607515 |  |  |  |  |  | 6 | CC00006 | 162.3569 |  | 36 | CC00036 | 639.2695 |  | 66 | CC00066 | 724.0837
7 | CC00007 | 473.6586 |  |  | CC00007 | 473.6586284296897 |  | CC00037 | 291.7213748804601 |  | CC00067 | 343.7865228948843 |  |  |  |  |  | 7 | CC00007 | 473.6586 |  | 37 | CC00037 | 291.7214 |  | 67 | CC00067 | 343.7865
8 | CC00008 | 877.5081 |  |  | CC00008 | 877.5081226970758 |  | CC00038 | 751.4143508352375 |  | CC00068 | 829.5265275617966 |  |  |  |  |  | 8 | CC00008 | 877.5081 |  | 38 | CC00038 | 751.4144 |  | 68 | CC00068 | 829.5265
9 | CC00009 | 248.2481 |  |  | CC00009 | 248.2480855511901 |  | CC00039 | 565.5921530777587 |  | CC00069 | 670.6267718098477 |  |  |  |  |  | 9 | CC00009 | 248.2481 |  | 39 | CC00039 | 565.5922 |  | 69 | CC00069 | 670.6268
10 | [NAME] | 646.3584 |  |  | [NAME] | 646.3584489243781 |  | CC00040 | 669.2514258060361 |  | CC00070 | 463.9957880157235 |  |  |  |  |  | 10 | [NAME] | 646.3584 |  | 40 | CC00040 | 669.2514 |  | 70 | CC00070 | 463.9958
11 | CC00011 | 38.8488 |  |  | CC00011 | 38.84884506782982 |  | CC00041 | 46.26206668669586 |  | CC00071 | 212.0786591584478 |  |  |  |  |  | 11 | CC00011 | 38.8488 |  | 41 | CC00041 | 46.2621 |  | 71 | CC00071 | 212.0787
12 | CC00012 | 388.286 |  |  | CC00012 | 388.2859613148622 |  | CC00042 | 52.9364930423849 |  | CC00072 | 346.2946220287966 |  |  |  |  |  | 12 | CC00012 | 388.286 |  | 42 | CC00042 | 52.9365 |  | 72 | CC00072 | 346.2946
13 | CC00013 | 85.766 |  |  | CC00013 | 85.76602739541516 |  | CC00043 | 554.2176991189871 |  | CC00073 | 850.4067389921963 |  |  |  |  |  | 13 | CC00013 | 85.766 |  | 43 | CC00043 | 554.2177 |  | 73 | CC00073 | 850.4067
14 | CC00014 | 357.9898 |  |  | CC00014 | 357.9898044424949 |  | CC00044 | 644.4341767562587 |  | CC00074 | 333.3755627276983 |  |  |  |  |  | 14 | CC00014 | 357.9898 |  | 44 | CC00044 | 644.4342 |  | 74 | CC00074 | 333.3756
15 | CC00015 | 217.0372 |  |  | CC00015 | 217.0372417865775 |  | CC00045 | 860.7579235053546 |  | CC00075 | 848.5071096858441 |  |  |  |  |  | 15 | CC00015 | 217.0372 |  | 45 | CC00045 | 860.7579 |  | 75 | CC00075 | 848.5071
16 | CC00016 | 88.3918 |  |  | CC00016 | 88.39175395212573 |  | CC00046 | 432.9572768760344 |  | CC00076 | 709.5304329130162 |  |  |  |  |  | 16 | CC00016 | 88.3918 |  | 46 | CC00046 | 432.9573 |  | 76 | CC00076 | 709.5304
17 | CC00017 | 318.1832 |  |  | CC00017 | 318.1832192025526 |  | CC00047 | 890.7976810517824 |  | CC00077 | 861.0135634117825 |  |  |  |  |  | 17 | CC00017 | 318.1832 |  | 47 | CC00047 | 890.7977 |  | 77 | CC00077 | 861.0136
18 | CC00018 | 164.4154 |  |  | CC00018 | 164.4153613104753 |  | CC00048 | 251.039386870056 |  | CC00078 | 569.1974876388427 |  |  |  |  |  | 18 | CC00018 | 164.4154 |  | 48 | CC00048 | 251.0394 |  | 78 | CC00078 | 569.1975
19 | CC00019 | 593.4488 |  |  | CC00019 | 593.4487684988869 |  | CC00049 | 799.4090354739611 |  | CC00079 | 317.9267682392655 |  |  |  |  |  | 19 | CC00019 | 593.4488 |  | 49 | CC00049 | 799.409 |  | 79 | CC00079 | 317.9268
20 | CC00020 | 589.1383 |  |  | CC00020 | 589.1382842763711 |  | CC00050 | 353.6072928072285 |  | CC00080 | 212.1018912432401 |  |  |  |  |  | 20 | CC00020 | 589.1383 |  | 50 | CC00050 | 353.6073 |  | 80 | CC00080 | 212.1019
21 | CC00021 | 46.8553 |  |  | CC00021 | 46.85530199572518 |  | CC00051 | 632.2541338446946 |  |  |  |  |  |  |  |  | 21 | CC00021 | 46.8553 |  | 51 | CC00051 | 632.2541
22 | CC00022 | 418.8681 |  |  | CC00022 | 418.8680690238032 |  | CC00052 | 758.322604313713 |  |  |  |  |  |  |  |  | 22 | CC00022 | 418.8681 |  | 52 | CC00052 | 758.3226
23 | CC00023 | 239.1357 |  |  | CC00023 | 239.1356690400853 |  | CC00053 | 3.376122582477992 |  |  |  |  |  |  |  |  | 23 | CC00023 | 239.1357 |  | 53 | CC00053 | 3.3761
24 | CC00024 | 255.5476 |  |  | CC00024 | 255.5475974658952 |  | CC00054 | 496.3788500333491 |  |  |  |  |  |  |  |  | 24 | CC00024 | 255.5476 |  | 54 | CC00054 | 496.3789
25 | CC00025 | 258.0712 |  |  | CC00025 | 258.071191177982 |  | CC00055 | 916.4276149858362 |  |  |  |  |  |  |  |  | 25 | CC00025 | 258.0712 |  | 55 | CC00055 | 916.4276
26 | CC00026 | 288.4695 |  |  | CC00026 | 288.4694816935164 |  | CC00056 | 777.1802175558345 |  |  |  |  |  |  |  |  | 26 | CC00026 | 288.4695 |  | 56 | CC00056 | 777.1802
27 | CC00027 | 827.1549 |  |  | CC00027 | 827.1548716495572 |  | CC00057 | 109.0960851064968 |  |  |  |  |  |  |  |  | 27 | CC00027 | 827.1549 |  | 57 | CC00057 | 109.0961
28 | CC00028 | 143.4624 |  |  | CC00028 | 143.4623971702464 |  | CC00058 | 805.8108457986107 |  |  |  |  |  |  |  |  | 28 | CC00028 | 143.4624 |  | 58 | CC00058 | 805.8108
29 | CC00029 | 115.257 |  |  | CC00029 | 115.2570072526528 |  | CC00059 | 618.724156595313 |  |  |  |  |  |  |  |  | 29 | CC00029 | 115.257 |  | 59 | CC00059 | 618.7242
30 | CC00030 | 684.3929 |  |  | CC00030 | 684.3929124756339 |  | CC00060 | 776.6508764014882 |  |  |  |  |  |  |  |  | 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