Spreadsheet: 861731d1709573728-data-transpose-from-columns-to-rows-power-query-data-transpose
Sheet: Table1

Location | Date | Attribute | Sum of Value
Bury | 2024-09-01 00:00:00 | AAT | 2767
 |  | ABC | 16611
 |  | ADC | 38179
 |  | BBA | 35250
 |  | BBE | 30380
 |  | CDR | 81126
 |  | NNT | 65035
 |  | NNY | 11346
 |  | NNY2 | 14923
 |  | XCY | 31742
 |  | XTY | 53307
 | 2025-04-01 00:00:00 | AAT | 74896
 |  | ABC | 49284
 |  | ADC | 61992
 |  | BBA | 17555
 |  | BBE | 67291
 |  | CDR | 17676
 |  | NNT | 55342
 |  | NNY | 74347
 |  | NNY2 | 60502
 |  | XCY | 15400
 |  | XTY | 27066
Crawley | 2024-08-01 00:00:00 | AAT | 34368
 |  | ABC | 26798
 |  | ADC | 16642
 |  | BBA | 25285
 |  | BBE | 78173
 |  | CDR | 83298
 |  | NNT | 82601
 |  | NNY | 74970
 |  | NNY2 | 9119
 |  | XCY | 72504
 |  | XTY | 80379
 | 2025-03-01 00:00:00 | AAT | 54247
 |  | ABC | 32328
 |  | ADC | 77421
 |  | BBA | 61230
 |  | BBE | 40249
 |  | CDR | 80846
 |  | NNT | 6536
 |  | NNY | 65610
 |  | NNY2 | 85066
 |  | XCY | 84454
 |  | XTY | 36643
Derby | 2024-07-01 00:00:00 | AAT | 8120
 |  | ABC | 59718
 |  | ADC | 37583
 |  | BBA | 22080
 |  | BBE | 84225
 |  | CDR | 85160
 |  | NNT | 67942
 |  | NNY | 2707
 |  | NNY2 | 39056
 |  | XCY | 79195
 |  | XTY | 22888
 | 2025-02-01 00:00:00 | AAT | 63521
 |  | ABC | 83253
 |  | ADC | 71904
 |  | BBA | 77674
 |  | BBE | 34332
 |  | CDR | 46044
 |  | NNT | 54773
 |  | NNY | 2564
 |  | NNY2 | 49743
 |  | XCY | 6562
 |  | XTY | 45043
 | 2025-09-01 00:00:00 | AAT | 77054
 |  | ABC | 40624
 |  | ADC | 75469
 |  | BBA | 17343
 |  | BBE | 17378
 |  | CDR | 12743
 |  | NNT | 3546
 |  | NNY | 62374
 |  | NNY2 | 53466
 |  | XCY | 2484
 |  | XTY | 55834
Enfileld | 2024-05-01 00:00:00 | AAT | 20794
 |  | ABC | 51020
 |  | ADC | 31059
 |  | BBA | 20463
 |  | BBE | 44654
 |  | CDR | 26423
 |  | NNT | 46350
 |  | NNY | 6907
 |  | NNY2 | 8385
 |  | XCY | 29887
 |  | XTY | 51437
 | 2024-12-01 00:00:00 | AAT | 61611
 |  | ABC | 51285
 |  | ADC | 57902
 |  | BBA | 52932
 |  | BBE | 30744
 |  | CDR | 50824
 |  | NNT | 15503
 |  | NNY | 35560
 |  | NNY2 | 40655
 |  | XCY | 71925
 |  | XTY | 38587
 | 2025-07-01 00:00:00 | AAT | 57110
 |  | ABC | 66841
 |  | ADC | 70954
 |  | BBA | 61725
 |  | BBE | 15089
 |  | CDR | 79410
 |  | NNT | 76607
 |  | NNY | 19933
 |  | NNY2 | 31659
 |  | XCY | 75737
 |  | XTY | 79442
London | 2024-04-01 00:00:00 | AAT | 79379
 |  | ABC | 40329
 |  | ADC | 66085
 |  | BBA | 38526
 |  | BBE | 70782
 |  | CDR | 21398
 |  | NNT | 40697
 |  | NNY | 57601
 |  | NNY2 | 20257
 |  | XCY | 3477
 |  | XTY | 43387
 | 2024-11-01 00:00:00 | AAT | 41671
 |  | ABC | 12813
 |  | ADC | 26750
 |  | BBA | 37653
 |  | BBE | 24215
 |  | CDR | 43646
 |  | NNT | 14027
 |  | NNY | 33337
 |  | NNY2 | 10747
 |  | XCY | 69457
 |  | XTY | 8879
 | 2025-06-01 00:00:00 | AAT | 43762
 |  | ABC | 13301
 |  | ADC | 22600
 |  | BBA | 67758
 |  | BBE | 62652
 |  | CDR | 41466
 |  | NNT | 16806
 |  | NNY | 82423
 |  | NNY2 | 48510
 |  | XCY | 18216
 |  | XTY | 74432
North Shield | 2024-10-01 00:00:00 | AAT | 81933
 |  | ABC | 3498
 |  | ADC | 17997
 |  | BBA | 62498
 |  | BBE | 11632
 |  | CDR | 61321
 |  | NNT | 69613
 |  | NNY | 35415
 |  | NNY2 | 68455
 |  | XCY | 57894
 |  | XTY | 35773
 | 2025-05-01 00:00:00 | AAT | 13855
 |  | ABC | 18937
 |  | ADC | 79908
 |  | BBA | 5612
 |  | BBE | 72431
 |  | CDR | 8191
 |  | NNT | 64293
 |  | NNY | 68712
 |  | NNY2 | 79501
 |  | XCY | 10559
 |  | XTY | 25406
Yor | 2024-06-01 00:00:00 | AAT | 51947
 |  | ABC | 22409
 |  | ADC | 3914
 |  | BBA | 41199
 |  | BBE | 84923
 |  | CDR | 79902
 |  | NNT | 35692
 |  | NNY | 60951
 |  | NNY2 | 30099
 |  | XCY | 11087
 |  | XTY | 26120
 | 2025-01-01 00:00:00 | AAT | 41314
 |  | ABC | 3626
 |  | ADC | 80988
 |  | BBA | 36213
 |  | BBE | 7629
 |  | CDR | 11122
 |  | NNT | 21725
 |  | NNY | 80534
 |  | NNY2 | 7979
 |  | XCY | 83196
 |  | XTY | 59744
 | 2025-08-01 00:00:00 | AAT | 14701
 |  | ABC | 7627
 |  | ADC | 46877
 |  | BBA | 48668
 |  | BBE | 79245
 |  | CDR | 50976
 |  | NNT | 22889
 |  | NNY | 50522
 |  | NNY2 | 63956
 |  | XCY | 13148
 |  | XTY | 17127
(blank) | (blank) | AAT | 823050
 |  | ABC | 600302
 |  | ADC | 884224
 |  | BBA | 729664
 |  | BBE | 856024
 |  | CDR | 881572
 |  | NNT | 759977
 |  | NNY | 825813
 |  | NNY2 | 722078
 |  | XCY | 736924
 |  | XTY | 781494
Grand Total |  |  | 17202244