Spreadsheet: 838380d1690975347-pairing-variables-and-coding-the-output-sample-dataset-v4-solution-1-
Sheet: Sheet01

Date (DD/MM/YYYY) | Customer ID | [NAME] | Red Apple | Green Pepper | Red Pepper | Orange Pepper | [NAME] | [NAME] | Blueberry | [NAME] | [NAME] | Peach | Grape
2021-08-01 00:00:00 | 111111 | 1 |  |  | 1 |  |  | 1 |  | 1 |  | 1
2021-08-01 00:00:00 | 111112 |  | 1 |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1
2021-08-01 00:00:00 | 111113 | 1 |  |  |  | 1 |  |  |  |  | 1
2021-08-02 00:00:00 | 111114 |  | 1
2021-08-02 00:00:00 | 111115 |  |  | 1 |  |  |  |  | 1 |  | 1
2021-08-02 00:00:00 | 111116 | 1 |  |  |  |  |  |  |  |  |  | 1
2021-08-02 00:00:00 | 111117 |  | 1 |  | 1 |  |  |  |  | 1 | 1
2021-08-02 00:00:00 | 111118 |  |  |  |  | 1 |  |  |  |  | 1 |  | 1
2021-08-05 00:00:00 | 111119 | 1 |  |  |  |  |  |  | 1
2021-08-06 00:00:00 | 111120 |  |  | 1 |  |  |  |  |  | 1 |  | 1
2021-08-07 00:00:00 | 111121 |  |  |  | 1
2021-08-07 00:00:00 | 111122 |  | 1 |  |  |  | 1 |  |  | 1 |  | 1
2021-08-07 00:00:00 | 111123 | 1 |  |  |  |  |  |  |  |  |  |  | 1
2021-08-07 00:00:00 | 111124 | 1 |  |  | 1 |  |  | 1 |  | 1 |  | 1
2021-08-07 00:00:00 | 111125 |  | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1
2021-08-09 00:00:00 | 111111 | 1 |  |  |  | 1 |  |  |  |  | 1
2021-08-10 00:00:00 | 111127 |  | 1
2021-08-10 00:00:00 | 111128 |  |  |  |  |  | 1 |  | 1 |  | 1
2021-08-10 00:00:00 | 111129 | 1 |  |  |  |  |  |  |  |  |  | 1
2021-08-10 00:00:00 | 111130 |  | 1 |  |  |  | 1 |  |  | 1 | 1
2021-08-10 00:00:00 | 111131 |  |  |  |  |  | 1 |  |  |  | 1 |  | 1
2021-08-11 00:00:00 | 111132 | 1 |  |  |  |  |  |  | 1
2021-08-11 00:00:00 | 111133 |  |  |  |  |  | 1 |  |  | 1 |  | 1
2021-08-11 00:00:00 | 111134 |  |  |  | 1
2021-08-11 00:00:00 | 111135 |  | 1 |  |  |  | 1 |  |  | 1 |  | 1
2021-08-11 00:00:00 | 111136 | 1 |  |  | 1 |  |  |  |  |  |  |  | 1
2021-08-11 00:00:00 | 111137 | 1 |  |  |  |  | 1 | 1 |  | 1 |  | 1
2021-08-11 00:00:00 | 111138 |  | 1 |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1
2021-08-11 00:00:00 | 111139 | 1 |  |  |  |  |  |  |  |  | 1
2021-08-11 00:00:00 | 111140 |  | 1 | 1
2021-08-12 00:00:00 | 111141 |  |  |  |  |  |  |  | 1 |  | 1
2021-08-12 00:00:00 | 111142 | 1 |  |  | 1 |  |  |  |  |  |  | 1
2021-08-13 00:00:00 | 111143 |  | 1 |  |  | 1 |  |  |  | 1 | 1
2021-08-14 00:00:00 | 111144 |  |  |  |  |  |  |  |  |  | 1 |  | 1
2021-08-15 00:00:00 | 111145 | 1 |  | 1 |  |  |  |  | 1
2021-08-16 00:00:00 | 111111 |  |  |  | 1 |  |  |  |  | 1 |  | 1
2021-08-16 00:00:00 | 111112 |  |  |  |  |  | 1
2021-08-17 00:00:00 | 111112 |  | 1 |  |  |  |  |  |  | 1 |  | 1
2021-08-17 00:00:00 | 111149 | 1 |  |  | 1 |  |  |  |  |  |  |  | 1
2021-08-17 00:00:00 | 111150 | 1 |  | 1 |  |  |  | 1 |  | 1 |  | 1
2021-08-17 00:00:00 | 111151 |  | 1 |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1
2021-08-17 00:00:00 | 111152 | 1 |  |  |  |  |  |  |  |  | 1
2021-08-17 00:00:00 | 111153 |  | 1 |  |  |  | 1
2021-08-17 00:00:00 | 111154 |  |  |  |  |  |  |  | 1 |  | 1
2021-08-17 00:00:00 | 111155 | 1 |  |  |  |  | 1 |  |  |  |  | 1
2021-08-17 00:00:00 | 111161 |  | 1 |  |  |  | 1 |  |  | 1 | 1
2021-08-17 00:00:00 | 111157 |  |  |  |  |  |  |  |  |  | 1 |  | 1
2021-08-17 00:00:00 | 111158 | 1 |  |  |  |  | 1 |  | 1
2021-08-17 00:00:00 | 111159 |  |  |  | 1 |  |  |  |  | 1 |  | 1
2021-08-18 00:00:00 | 111160 |  |  |  |  |  | 1
2021-08-18 00:00:00 | 111161 |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
2021-08-18 00:00:00 | 111162 | 1 |  |  |  |  | 1 |  |  |  |  |  | 1
2021-08-18 00:00:00 | 111163 | 1 |  |  |  | 1 |  | 1 |  | 1 |  | 1
2021-08-18 00:00:00 | 111164 |  | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
2021-08-18 00:00:00 | 111165 | 1 |  | 1 |  |  |  |  |  |  | 1
2021-08-18 00:00:00 | 111166 |  | 1
2021-08-18 00:00:00 | 111167 |  |  |  | 1 |  |  |  | 1 |  | 1
2021-08-18 00:00:00 | 111168 | 1 |  |  |  | 1 |  |  |  |  |  | 1
2021-08-18 00:00:00 | 111169 |  | 1 |  |  |  |  |  |  | 1 | 1
2021-08-18 00:00:00 | 111170 |  |  | 1 |  |  |  |  |  |  | 1 |  | 1
2021-08-19 00:00:00 | 111171 | 1 |  |  | 1 |  |  |  | 1
2021-08-19 00:00:00 | 111172 |  |  |  |  |  | 1 |  |  | 1 |  | 1
2021-08-19 00:00:00 | 111173
2021-08-19 00:00:00 | 111174 |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
2021-08-19 00:00:00 | 111175 | 1 |  | 1 |  |  |  |  |  |  |  |  | 1
2021-08-19 00:00:00 | 111176 | 1 |  |  |  | 1 |  | 1 |  | 1 |  | 1
2021-08-19 00:00:00 | 111177 |  | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
2021-08-19 00:00:00 | 111178 | 1 |  |  |  |  | 1 |  |  |  | 1
2021-08-19 00:00:00 | 111179 |  | 1
2021-08-19 00:00:00 | 111180 |  |  |  |  |  | 1 |  | 1 |  | 1
2021-08-20 00:00:00 | 111181 | 1 |  |  |  |  | 1 |  |  |  |  | 1
2021-08-20 00:00:00 | 111182 |  | 1 |  |  |  |  |  |  | 1 | 1
2021-08-20 00:00:00 | 111183 |  |  |  |  |  | 1 |  |  |  | 1 |  | 1
2021-08-20 00:00:00 | 111184 | 1 |  |  | 1 |  |  |  | 1
2021-08-20 00:00:00 | 111185 |  |  |  |  |  | 1 |  |  | 1 |  | 1
2021-08-20 00:00:00 | 111186 |  |  |  | 1
2021-08-20 00:00:00 | 111187 |  | 1 |  |  |  | 1 |  |  | 1 |  | 1
2021-08-20 00:00:00 | 111133 | 1 |  |  |  | 1 |  |  |  |  |  |  | 1
2021-08-21 00:00:00 | 111189 | 1 |  |  |  |  |  | 1 |  | 1 |  | 1
2021-08-21 00:00:00 | 111181 |  | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1
2021-08-22 00:00:00 | 111191 | 1 |  |  |  |  |  |  |  |  | 1
2021-08-22 00:00:00 | 111192 |  | 1 |  | 1
2021-08-22 00:00:00 | 111193 |  |  |  |  | 1 |  |  | 1 |  | 1
2021-08-22 00:00:00 | 111194 | 1 |  |  |  |  |  |  |  |  |  | 1
2021-08-22 00:00:00 | 111195 |  | 1 | 1 |  |  |  |  |  | 1 | 1
2021-08-22 00:00:00 | 111196 |  |  |  | 1 |  |  |  |  |  | 1 |  | 1
2021-08-22 00:00:00 | 111197 | 1 |  |  |  |  | 1 |  | 1
2021-08-23 00:00:00 | 111198 |  |  |  |  |  |  |  |  | 1 |  | 1
2021-08-23 00:00:00 | 111199 |  |  |  | 1
2021-08-23 00:00:00 | 111200 |  | 1 | 1 |  |  |  |  |  | 1 |  | 1
2021-08-23 00:00:00 | 111201 | 1 |  |  |  | 1 |  |  |  |  |  |  | 1
2021-08-23 00:00:00 | 111202 | 1 |  |  |  |  |  | 1 |  | 1 |  | 1
2021-08-23 00:00:00 | 111203 |  | 1 |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1
2021-08-23 00:00:00 | 111204 | 1 |  |  |  |  |  |  |  |  | 1
2021-08-23 00:00:00 | 111205 |  | 1 |  |  |  | 1
2021-08-24 00:00:00 | 111206 |  |  |  |  |  | 1 |  | 1 |  | 1
2021-08-25 00:00:00 | 111207 | 1 |  |  |  |  |  |  |  |  |  | 1
2021-08-28 00:00:00 | 111209 |  | 1 |  |  |  | 1 |  |  | 1 | 1
2021-08-29 00:00:00 | 111209 |  |  |  | 1 |  |  |  |  |  | 1 |  | 1
2021-08-30 00:00:00 | 111209 | 1 |  |  |  |  | 1 |  | 1