Input
Weekly Challenge #49
Data Manipulation - Reformatting data
A customer has some data that comes with key product information stored at the top of the file. Each data column contains three lines of header information per product (product, market and type). The customer wants this information to be shown in rows for each product.
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\garcr\AppData\Local\Temp\Engine_21072_51423c0a7ff44a1191a1227483b6d86f_\Engine_20488_835f6e05416f431d8d8ed923993ef94d_.yxdb
Single
Profile
RecordID
1
Int32
6
0
Simple
<=
RecordID
True
fixed
2021-11-17 13:00:05
0
3
2021-11-17 13:00:05
2021-11-17 13:00:05
[RecordID] <= 3
Warn
Warn
,
Horizontal
challenge_49_start_file