Spreadsheet: 731553d1620405212-rearrange-data-in-a-worksheet-sampleexcelwksht_gfd
Sheet: Example A

RecipientID | BillingMonth | BillingYear | WK1_1 | WK1_2 | WK1_3 | WK1_4 | WK1_5 | WK2_6 | WK2_7 | WK2_8 | WK2_9 | WK2_10 | WK3_11 | WK3_12 | WK3_13 | WK3_14 | WK3_15 | [NAME] | [NAME] | WK4_18 | [NAME] | WK4_20 | [NAME] | WK5_22 | WK5_23 | WK5_24 | WK5_25
302476056 | Nov | 2018 | 0 | 0 | 0 | 229.2 | 0 | 229.2 | 229.2 | 229.2 | 257.85 | 229.2 | 229.2 | 248.3 | 0 | 133.7 | 152.8 | 229.2 | 248.3 | 0 | 0 | 0 | 229.2 | 248.3 | 229.2 | 229.2 | 229.2
304423379 | Nov | 2018 | 0 | 0 | 0 | 143.92 | 0 | 143.92 | 143.92 | 143.92 | 143.92 | 138.78 | 143.92 | 143.92 | 143.92 | 0 | 0 | 143.92 | 143.92 | 0 | 0 | 0 | 143.92 | 143.92 | 138.78 | 143.92 | 143.92
401413034 | Nov | 2018 | 0 | 0 | 0 | 133.64 | 0 | 128.5 | 0 | 128.5 | 123.36 | 0 | 128.5 | 0 | 128.5 | 51.4 | 0 | 133.64 | 0 | 0 | 0 | 0 | 0 | 0 | 133.64 | 128.5 | 0
601871353 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 133.64 | 133.64 | 0 | 0 | 128.5 | 128.5 | 133.64 | 0 | 0 | 102.8 | 133.64 | 0 | 0 | 0 | 0 | 123.36 | 128.5 | 0 | 0 | 133.64
901640896 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 115.7 | 80.1 | 0 | 0 | 93.45 | 106.8 | 0 | 0 | 0 | 111.25 | 0 | 0 | 0 | 0 | 111.25 | 111.25 | 102.35 | 0
1001199387 | Nov | 2018 | 0 | 0 | 0 | 89.28 | 0 | 0 | 122.76 | 117.18 | 117.18 | 133.92 | 128.34 | 117.18 | 117.18 | 0 | 111.6 | 128.34 | 117.18 | 0 | 0 | 0 | 128.34 | 117.18 | 122.76 | 89.28 | 128.34
1201190020 | Nov | 2018 | 0 | 0 | 0 | 139.5 | 0 | 128.34 | 133.92 | 111.6 | 0 | 128.34 | 133.92 | 133.92 | 117.18 | 0 | 0 | 117.18 | 150.66 | 0 | 0 | 0 | 117.18 | 117.18 | 150.66 | 128.34 | 66.96
1601290545 | Nov | 2018 | 0 | 0 | 0 | 139.5 | 0 | 139.5 | 145.08 | 139.5 | 145.08 | 145.08 | 139.5 | 145.08 | 139.5 | 0 | 100.44 | 139.5 | 139.5 | 0 | 0 | 0 | 139.5 | 139.5 | 100.44 | 89.28 | 139.5
1601370487 | Nov | 2018 | 0 | 0 | 0 | 117.18 | 0 | 100.44 | 133.92 | 94.86 | 133.92 | 111.6 | 72.54 | 128.34 | 111.6 | 78.12 | 0 | 94.86 | 128.34 | 0 | 0 | 0 | 50.22 | 89.28 | 106.02 | 128.34 | 117.18
1901409688 | Nov | 2018 | 0 | 0 | 0 | 117.18 | 0 | 122.76 | 133.92 | 122.76 | 122.76 | 133.92 | 122.76 | 128.34 | 128.34 | 78.12 | 0 | 122.76 | 128.34 | 0 | 0 | 0 | 128.34 | 122.76 | 89.28 | 128.34 | 133.92
2001232905 | Nov | 2018 | 0 | 0 | 0 | 133.92 | 0 | 128.34 | 128.34 | 122.76 | 133.92 | 145.08 | 133.92 | 122.76 | 128.34 | 0 | 94.86 | 122.76 | 139.5 | 0 | 0 | 0 | 133.92 | 139.5 | 133.92 | 0 | 139.5
2101022974 | Nov | 2018 | 0 | 0 | 0 | 111.6 | 0 | 122.76 | 122.76 | 117.18 | 117.18 | 0 | 128.34 | 117.18 | 117.18 | 117.18 | 0 | 128.34 | 117.18 | 0 | 0 | 0 | 128.34 | 117.18 | 122.76 | 122.76 | 128.34
2101291520 | Nov | 2018 | 0 | 0 | 0 | 128.5 | 0 | 128.5 | 128.5 | 133.64 | 133.64 | 128.5 | 128.5 | 128.5 | 128.5 | 92.52 | 0 | 133.64 | 128.5 | 0 | 0 | 0 | 128.5 | 128.5 | 128.5 | 128.5 | 128.5
2301244956 | Nov | 2018 | 0 | 0 | 0 | 60.86 | 0 | 60.86 | 60.86 | 60.86 | 0 | 0 | 60.86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2403238765 | Nov | 2018 | 0 | 0 | 0 | 107.94 | 0 | 0 | 113.08 | 107.94 | 107.94 | 123.36 | 0 | 0 | 0 | 0 | 0 | 0 | 107.94 | 0 | 0 | 0 | 0 | 107.94 | 92.52 | 102.8 | 107.94
3101333312 | Nov | 2018 | 0 | 0 | 0 | 102.8 | 0 | 107.94 | 61.68 | 123.36 | 133.64 | 123.36 | 128.5 | 61.68 | 128.5 | 71.96 | 97.66 | 118.22 | 118.22 | 0 | 0 | 0 | 123.36 | 123.36 | 123.36 | 0 | 0
3701331179 | Nov | 2018 | 0 | 0 | 0 | 115.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80.1 | 0 | 0 | 129.05 | 0 | 0 | 0 | 0 | 120.15 | 115.7 | 120.15 | 0
4201383280 | Nov | 2018 | 0 | 0 | 0 | 111.25 | 0 | 0 | 111.25 | 0 | 115.7 | 115.7 | 0 | 111.25 | 0 | 57.85 | 89 | 0 | 111.25 | 0 | 0 | 0 | 0 | 106.8 | 0 | 115.7 | 111.25
4601412366 | Nov | 2018 | 0 | 0 | 0 | 102.35 | 0 | 102.35 | 106.8 | 102.35 | 102.35 | 102.35 | 0 | 102.35 | 0 | 0 | 0 | 102.35 | 102.35 | 0 | 0 | 0 | 102.35 | 102.35 | 102.35 | 84.55 | 111.25
4701174189 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 0 | 143.92 | 143.92 | 138.78 | 0 | 0 | 138.78 | 143.92 | 87.38 | 0 | 0 | 143.92 | 0 | 0 | 0 | 0 | 138.78 | 143.92 | 143.92 | 0
4801218308 | Nov | 2018 | 0 | 0 | 0 | 128.34 | 0 | 145.08 | 139.5 | 139.5 | 139.5 | 139.5 | 139.5 | 0 | 0 | 0 | 0 | 139.5 | 139.5 | 0 | 0 | 0 | 139.5 | 0 | 0 | 0 | 0
4901239238 | Nov | 2018 | 0 | 0 | 0 | 257.85 | 0 | 248.3 | 257.85 | 267.4 | 248.3 | 229.2 | 257.85 | 257.85 | 257.85 | 143.25 | 191 | 248.3 | 248.3 | 0 | 0 | 0 | 219.65 | 257.85 | 257.85 | 257.85 | 257.85
4901337123 | Nov | 2018 | 0 | 0 | 0 | 124.6 | 0 | 120.15 | 0 | 124.6 | 124.6 | 0 | 120.15 | 0 | 124.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5001003226 | Nov | 2018 | 0 | 0 | 0 | 150.66 | 0 | 150.66 | 156.24 | 139.5 | 156.24 | 156.24 | 150.66 | 156.24 | 156.24 | 133.92 | 111.6 | 150.66 | 156.24 | 0 | 0 | 0 | 156.24 | 156.24 | 156.24 | 150.66 | 150.66
5001553147 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 120.15 | 0 | 129.05 | 0 | 0 | 0 | 0 | 124.6 | 0 | 89 | 124.6 | 0 | 0 | 0 | 0 | 111.25 | 0 | 129.05 | 0 | 120.15
5901242387 | Nov | 2018 | 0 | 0 | 0 | 117.18 | 0 | 111.6 | 122.76 | 117.18 | 122.76 | 145.08 | 128.34 | 111.6 | 117.18 | 111.6 | 0 | 117.18 | 122.76 | 0 | 0 | 0 | 117.18 | 122.76 | 117.18 | 117.18 | 66.96
6301217276 | Nov | 2018 | 0 | 0 | 0 | 118.22 | 0 | 133.64 | 133.64 | 133.64 | 133.64 | 133.64 | 133.64 | 138.78 | 138.78 | 66.82 | 107.94 | 128.5 | 133.64 | 0 | 0 | 0 | 133.64 | 138.78 | 138.78 | 138.78 | 138.78
6601243352 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 120.15 | 124.6 | 129.05 | 0 | 0 | 120.15 | 124.6 | 124.6 | 0 | 0 | 124.6 | 124.6 | 0 | 0 | 0 | 115.7 | 120.15 | 129.05 | 0 | 0
7001283220 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 0 | 143.92 | 0 | 0 | 143.92 | 0 | 143.92 | 0 | 0 | 102.8 | 0 | 143.92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 143.92
7201440554 | Nov | 2018 | 0 | 0 | 0 | 138.78 | 0 | 133.64 | 0 | 143.92 | 143.92 | 138.78 | 102.8 | 128.5 | 138.78 | 46.26 | 0 | 143.92 | 138.78 | 0 | 0 | 0 | 0 | 128.5 | 138.78 | 143.92 | 138.78
7801143566 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 106.8 | 0 | 106.8 | 0 | 111.25 | 0 | 0 | 106.8 | 0 | 80.1 | 106.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 106.8
8401335354 | Nov | 2018 | 0 | 0 | 0 | 106.8 | 0 | 115.7 | 106.8 | 106.8 | 106.8 | 115.7 | 106.8 | 120.15 | 120.15 | 48.95 | 89 | 106.8 | 106.8 | 0 | 0 | 0 | 106.8 | 106.8 | 106.8 | 106.8 | 106.8
8401660371 | Nov | 2018 | 0 | 0 | 0 | 120.15 | 0 | 0 | 0 | 124.6 | 120.15 | 0 | 0 | 124.6 | 124.6 | 75.65 | 0 | 0 | 129.05 | 0 | 0 | 0 | 0 | 120.15 | 124.6 | 124.6 | 0
8601114864 | Nov | 2018 | 0 | 0 | 0 | 139.5 | 0 | 139.5 | 133.92 | 133.92 | 145.08 | 133.92 | 133.92 | 133.92 | 139.5 | 0 | 0 | 133.92 | 133.92 | 0 | 0 | 0 | 133.92 | 128.34 | 133.92 | 133.92 | 133.92
8700095022 | Nov | 2018 | 0 | 0 | 0 | 128.34 | 0 | 122.76 | 133.92 | 117.18 | 128.34 | 128.34 | 128.34 | 122.76 | 128.34 | 111.6 | 89.28 | 128.34 | 128.34 | 0 | 0 | 0 | 128.34 | 133.92 | 128.34 | 122.76 | 122.76
8701468319 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 138.78 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 143.92 | 0
8901176480 | Nov | 2018 | 0 | 0 | 0 | 120.15 | 0 | 120.15 | 84.55 | 115.7 | 120.15 | 124.6 | 115.7 | 120.15 | 115.7 | 71.2 | 89 | 124.6 | 124.6 | 0 | 0 | 0 | 0 | 115.7 | 115.7 | 120.15 | 124.6
9001471557 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 106.8 | 111.25 | 0 | 0 | 106.8 | 106.8 | 0 | 0 | 0 | 75.65 | 106.8 | 0 | 0 | 0 | 0 | 106.8 | 0 | 0 | 0 | 106.8
9100037408 | Nov | 2018 | 0 | 0 | 0 | 122.76 | 0 | 117.18 | 122.76 | 122.76 | 128.34 | 122.76 | 122.76 | 122.76 | 133.92 | 0 | 0 | 122.76 | 122.76 | 0 | 0 | 0 | 122.76 | 122.76 | 122.76 | 122.76 | 117.18
9501248141 | Nov | 2018 | 0 | 0 | 0 | 122.76 | 0 | 128.34 | 122.76 | 122.76 | 122.76 | 122.76 | 117.18 | 122.76 | 122.76 | 55.8 | 0 | 122.76 | 122.76 | 0 | 0 | 0 | 122.76 | 122.76 | 122.76 | 117.18 | 117.18
9601152730 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 133.92 | 133.92 | 133.92 | 133.92 | 128.34 | 133.92 | 128.34 | 133.92 | 78.12 | 111.6 | 128.34 | 122.76 | 0 | 0 | 0 | 128.34 | 128.34 | 128.34 | 128.34 | 128.34
9601311146 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 106.8 | 0 | 0 | 0 | 111.25 | 111.25 | 0 | 0 | 0 | 89 | 106.8 | 0 | 0 | 0 | 0 | 102.35 | 0 | 0 | 0 | 115.7
9801559981 | Nov | 2018 | 0 | 0 | 0 | 143.92 | 0 | 0 | 143.92 | 0 | 102.8 | 143.92 | 0 | 143.92 | 0 | 87.38 | 97.66 | 0 | 143.92 | 0 | 0 | 0 | 0 | 143.92 | 0 | 133.64 | 143.92
9901294638 | Nov | 2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 115.7 | 0 | 120.15 | 0 | 0 | 84.55 | 0 | 120.15 | 0 | 0 | 0 | 0 | 124.6 | 0 | 0 | 124.6
302476056 | Apr | 2019 | 191 | 95.5 | 229.2 | 181.45 | 229.2 | 152.8 | 238.75 | 229.2 | 229.2 | 229.2 | 181.45 | 219.65 | 229.2 | 0 | 0 | 229.2 | 229.2 | 229.2 | 229.2 | 229.2 | 210.1 | 248.3 | 0 | 0 | 0
304423379 | Apr | 2019 | 106.8 | 106.8 | 97.9 | 97.9 | 89 | 57.85 | 80.1 | 124.6 | 124.6 | 124.6 | 124.6 | 66.75 | 93.45 | 0 | 0 | 97.9 | 93.45 | 57.85 | 84.55 | 93.45 | 124.6 | 124.6 | 0 | 0 | 0
401413034 | Apr | 2019 | 102.8 | 0 | 92.52 | 87.38 | 0 | 133.64 | 0 | 107.94 | 71.96 | 0 | 128.5 | 0 | 97.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 138.78 | 0 | 0 | 0 | 0
601871353 | Apr | 2019 | 97.9 | 115.7 | 0 | 0 | 102.35 | 89 | 115.7 | 0 | 0 | 80.1 | 75.65 | 57.85 | 0 | 0 | 0 | 102.35 | 93.45 | 0 | 26.7 | 97.9 | 80.1 | 120.15 | 0 | 0 | 0
901640896 | Apr | 2019 | 0 | 97.9 | 93.45 | 62.3 | 0 | 0 | 111.25 | 62.3 | 115.7 | 0 | 0 | 53.4 | 66.75 | 0 | 0 | 0 | 89 | 75.65 | 75.65 | 0 | 0 | 106.8 | 0 | 0 | 0