create headers & rows for key product info
PRODUCT
Product A
Product B
Product C
Product D
MARKET
Market A
Market B
Market C
Market D
TYPE
Type A
Type B
Type C
2005-01-01
933
389.10500000000002
393.46100000000001
1020
2005-02-01
770
412.49299999999999
416.49299999999999
970
2005-03-01
770
472.351
477.76799999999997
970
2005-04-01
715
466.91699999999997
471.762
930
2005-05-01
613
414.13799999999998
418.76299999999998
880
2005-06-01
530
433.67
437.67
840
2005-07-01
576
464.363
468.363
840
2005-08-01
680
523.77300000000002
527.77300000000002
920
2005-09-01
895
566.55999999999995
570.55999999999995
1020
2005-10-01
1063
542.26199999999994
546.26199999999994
1200
2005-11-01
820
476.58800000000002
480.58800000000002
1160
2005-12-01
770
494.113
498.113
1030
2006-01-01
822
557.46299999999997
561.46299999999997
1030
2006-02-01
1010
520.64499999999998
524.63800000000003
1090
2006-03-01
965
523.81500000000005
527.81500000000005
1110
2006-04-01
910
587.23599999999999
591.23599999999999
1130
2006-05-01
943
596.59500000000003
600.63099999999997
1180
2006-06-01
921
611
615
1200
2006-07-01
948
639.197
643.197
1200
2006-08-01
1056
616.43200000000002
620.43200000000002
1225
2006-09-01
1100
520.5
521.9
1275
2006-10-01
1109
504
507.98899999999998
1255
2006-11-01
1041
511.16300000000001
515.16300000000001
1200
2006-12-01
970
541.77599999999995
545.77599999999995
1150
2007-01-01
957
505.65499999999997
509.65499999999997
1170
2007-02-01
983
547.57899999999995
552.10500000000002
1190
2007-03-01
921
600.30700000000002
604.30700000000002
1205
2007-04-01
940
653.16399999999999
657.18399999999997
1230
2007-05-01
941
682.34500000000003
686.34500000000003
1250
2007-06-01
911
663.82100000000003
667.66700000000003
1270
2007-07-01
933
680.63099999999997
684.26199999999994
1295
2007-08-01
965
641.86400000000003
645.61400000000003
1310
2007-09-01
980
692.64499999999998
697.15800000000002
1320
2007-10-01
1006
749.22799999999995
745.65200000000004
1320
2007-11-01
949
821.11900000000003
825.11900000000003
1300
2007-12-01
967
840.23500000000001
837.529
1300
2008-01-01
969
824.78599999999994
828.78599999999994
1350
2008-02-01
976
828.96299999999997
832.21299999999997
1350
2008-03-01
1005
860.95799999999997
864.95799999999997
1340
2008-04-01
1025
903.28399999999999
905.01099999999997
1320
2008-05-01
1027.5
982.96299999999997
986.96299999999997
1300
2008-06-01
1126
1087.857
1091.857
1330
2008-07-01
1204
1074.2159999999999
1078.2159999999999
1495
2008-08-01
1180
951.41300000000001
955.41300000000001
1525
2008-09-01
1022
839.06
843.06
1485
2008-10-01
801
524.75
528.75
1235
2008-11-01
688
301.66699999999997
305.66699999999997
950
2008-12-01
530
254.167
258.16699999999997
800
2009-01-01
525
348.36900000000003
352.13099999999997
780
2009-02-01
606
393.738
397.738
820
2009-03-01
630
394.36399999999998
398.18200000000002
880
2009-04-01
566
421.55
425.55
880
2009-05-01
570
473.22399999999999
477.22399999999999
870
2009-06-01
615
564.66999999999996
568.69299999999998
890
2009-07-01
688
552.28300000000002
556.28300000000002
990
2009-08-01
798.75
637.68799999999999
641.98099999999999
1020
2009-09-01
810
592.375
596.375
1110
2009-10-01
740.625
624.976
628.976
1070
2009-11-01
730
670.25
674.25
1020
2009-12-01
746
678.78099999999995
684.125
1020
2010-01-01
836.25
711.06600000000003
715.06600000000003
1080
2010-02-01
841.25
676.03899999999999
680.82899999999995
1160
2010-03-01
819
727.41300000000001
731.41300000000001
1160
2010-04-01
812.5
732.82500000000005
736.82500000000005
1180
2010-05-01
887.5
677.23699999999997
681.23699999999997
1190
2010-06-01
940
655.26099999999997
659.26099999999997
1190
2010-07-01
915
625.01199999999994
629.01199999999994
1175
2010-08-01
948.75
659.57100000000003
662.51199999999994
1150
2010-09-01
927
676.351
682.774
1140
2010-10-01
915
751.202
755.20299999999997
1130
2010-11-01
938.75
776.32500000000005
780.32500000000005
1150
2010-12-01
994
837.3
841.3
1190
2011-01-01
1090
850.32899999999995
854.32899999999995
1310
2011-02-01
1113.125
877.63800000000003
881.63800000000003
1360
2011-03-01
1155
977.44600000000003
981.44600000000003
1440
2011-04-01
1195
1048.681
1052.681
1460
2011-05-01
1205.625
982.41300000000001
986.41300000000001
1475
2011-06-01
980
929.31799999999998
933.31799999999998
1420
2011-07-01
886.25
975.798
979.798
1320
2011-08-01
989
936.125
940.125
1325
2011-09-01
992.5
936.04499999999996
940.04499999999996
1320
2011-10-01
951.25
878.34500000000003
882.34500000000003
1320
2011-11-01
908
860.61400000000003
864.61400000000003
1280
2011-12-01
881.25
872.68799999999999
876.68799999999999
1260
2012-01-01
1036.25
946.60699999999997
950.60699999999997
1315
2012-02-01
1200
1022.881
1026.8810000000001
1440
2012-03-01
1303.75
1064.8409999999999
1068.8409999999999
1550
2012-04-01
1243.75
1025.5129999999999
1029.5129999999999
1585
2012-05-01
1035
873.11400000000003
877.11400000000003
1530
2012-06-01
856.25
725.48699999999997
729.48699999999997
1360
2012-07-01
935
821.39800000000002
825.39800000000002
1240
2012-08-01
1110
931.18200000000002
935.18200000000002
1400
2012-09-01
1222.5
962.06299999999999
966.06299999999999
1560
2012-10-01
1197
950.58699999999999
954.58699999999999
1520
2012-11-01
1150
926.98900000000003
930.98900000000003
1480
2012-12-01
1065
934.47400000000005
938.47400000000005
1480
2013-01-01
1154
150
932.95500000000004
1510
2013-02-01
1182.5
942
991.86300000000006
1510
2013-03-01
1116.25
286
910.28800000000001
1525
2013-04-01
1037.5
642
815.702
1460
2013-05-01
932.5
677
833.202
1370
2013-06-01
975
143
843.6
1390
2013-07-01
1031
588
876.79
1390
2013-08-01
1097.5
321
913.88
1430
2013-09-01
1107.5
261
929.81
1480
2013-10-01
1030
707
901.87
1430
2013-11-01
980
380
929.33
1395
2013-12-01
971
923
956.78
1420
2014-01-01
998
518
918.58
1440
2014-02-01
940
495
913.65
1400
2014-03-01
902.5
516
911.4
1380
2014-04-01
872.5
93
925.61
1370
2014-05-01
891.875
566
937.84
1370
2014-06-01
992.5
454
952.45
1380
2014-07-01
1033
627
935.51
1420
2014-08-01
1003.75
998
865.81
1400
2014-09-01
923.75
813
842.82
1345
2014-10-01
993
872
711.52
1345
2014-11-01
997.5
223
628.94000000000005
1280
2014-12-01
869
511
491.98
1245
2015-01-01
710.63
391.34
396.9
1125
2015-02-01
753.13
496.5
502.13
1070
2015-03-01
118
819
504.86
1200
2015-04-01
292
485
666
684
2015-05-01
570
339
160
704
2015-06-01
483
353
786
349
2015-07-01
630
41
682
79
2015-08-01
7
859
101
676
2015-09-01
610
927
717
944
2015-10-01
498
963
689
1
2015-11-01
442
763
0
661
2015-12-01
936
598
829
490
2016-01-01
436
131
925
737
2016-02-01
67
578
522
271
2016-03-01
704
8
369
565
2016-04-01
207
688
476
3
2016-05-01
825
904
620
401
2016-06-01
428
149
794
637
2016-07-01
496
120
93
902
2016-08-01
285
668
822
337
2016-09-01
26
315
144
542
2016-10-01
199
144
399
613
2016-11-01
969
186
778
864
2016-12-01
28
444
21
300
2017-01-01
101
486
521
332
2017-02-01
905
969
826
700
2017-03-01
923
331
99
487
2017-04-01
544
823
142
438
2017-05-01
505
520
519
872
2017-06-01
271
581
789
285
2017-07-01
668
437
865
266
2017-08-01
508
786
831
826
2017-09-01
950
995
43
759
2017-10-01
511
291
574
607
2017-11-01
548
77
559
47
2017-12-01
728
301
662
842
2018-01-01
612
219
670
76
2018-02-01
525
634
490
390
2018-03-01
533
236
481
204
2018-04-01
218
206
251
845
2018-05-01
778
210
158
306
2018-06-01
880
136
641
794
2018-07-01
458
506
446
731
2018-08-01
759
652
326
21
2018-09-01
839
905
641
306
2018-10-01
511
962
317
848
2018-11-01
201
738
759
575
2018-12-01
682
161
964
173
2019-01-01
130
863
392
122
2019-02-01
267
666
914
372
2019-03-01
235
341
956
658
2019-04-01
220
476
605
489
2019-05-01
299
922
859
548
2019-06-01
620
93
958
406
2019-07-01
379
866
298
463
2019-08-01
181
873
435
227
2019-09-01
568
561
718
41
2019-10-01
387
763
139
837
2019-11-01
360
677
333
997
2019-12-01
88
235
432
739
2020-01-01
816
197
122
336
2020-02-01
457
302
124
93
2020-03-01
624
669
74
146
2020-04-01
659
975
903
530
2020-05-01
56
950
548
268
2020-06-01
139
997
126
536
2020-07-01
718
41
348
590
2020-08-01
184
143
830
852
2020-09-01
968
623
697
543
2020-10-01
846
264
715
150
2020-11-01
258
327
993
903
2020-12-01
820
725
914
993
2021-01-01
681
144
839
773
2021-02-01
367
269
414
178
2021-03-01
828
225
954
885
2021-04-01
15
433
673
531
2021-05-01
72
633
117
224
2021-06-01
706
483
705
797
2021-07-01
326
144
873
464
2021-08-01
420
628
889
25
2021-09-01
810
93
191
83
2021-10-01
483
817
531
329
2021-11-01
904
905
770
84
2021-12-01
342
323
68
748
2022-01-01
138
912
113
702
2022-02-01
632
689
269
669
2022-03-01
385
924
160
459
2022-04-01
103
666
511
869
2022-05-01
14
516
659
261
2022-06-01
145
203
179
308
2022-07-01
348
813
319
440
2022-08-01
722
78
261
333
2022-09-01
281
401
579
287
2022-10-01
809
158
884
298
2022-11-01
421
487
24
225
2022-12-01
957
583
180
989
2023-01-01
368
712
823
451
2023-02-01
194
666
878
740
2023-03-01
633
640
839
97
2023-04-01
891
187
237
184
2023-05-01
581
719
338
309
2023-06-01
860
914
454
907
2023-07-01
255
723
276
727
2023-08-01
616
467
333
144
2023-09-01
936
602
786
572
2023-10-01
593
159
457
653
2023-11-01
211
594
646
928
2023-12-01
990
288
971
944
2024-01-01
721
767
321
445
2024-02-01
70
985
539
385
2024-03-01
504
845
980
711
2024-04-01
127
474
384
581
2024-05-01
502
950
50
977
2024-06-01
100
614
666
378
2024-07-01
501
247
63
952
2024-08-01
320
547
923
927
2024-09-01
840
317
171
411
2024-10-01
881
609
507
397
2024-11-01
425
760
304
464
2024-12-01
288
467
208
526
2025-01-01
64
908
752
173
2025-02-01
618
867
599
372
2025-03-01
174
156
939
699
2025-04-01
729
847
726
905
2025-05-01
541
279
557
356
2025-06-01
655
747
718
0
2025-07-01
925
216
232
906
2025-08-01
459
771
949
14
2025-09-01
211
728
736
683
2025-10-01
479
100
977
972
2025-11-01
772
104
861
706
2025-12-01
334
894
367
392
C:\Users\ESTHER~1\AppData\Local\Temp\Engine_8620_e0aa5c0f4acd4c75813157d05ae35c21_\Engine_18992_df4384ef1d7e4bef9fc8a0f2439b9e4b_.yxdb
Single
Profile
!Contains([F1],"2")
Custom
!Contains([F1],"2")
Warn
RecordID
1
Int32
6
0
"F1","F2","F3","F4","F5"
False
False
True
False
False
False
False
False
False
upper
,
Warn
transpose to join
to key rows
C:\Users\ESTHER~1\AppData\Local\Temp\Engine_8620_e0aa5c0f4acd4c75813157d05ae35c21_\Engine_18992_952d87fe8633493ca5c3be87cd6b0cf5_.yxdb
Horizontal
challenge_49_EHB_solution