Spreadsheet: 687448d1595229085-replace-duplicates-with-null-by-power-query-data
Sheet: Sheet1

ID | Description1 | Status1 |  | AITS | Description2 | ID | Status2 |  | ID | Description1 | Status1 | AITS | Description2 |  | ID | Description1 | Status1 | AITS | Description2
[NAME] | text1 | P |  | 123456 | Text111 | AA-1238 | C |  | [NAME] | text1 | P |  |  |  | [NAME] | text1 | P
AA-1235 | text2 | V |  | 123457 | Text112 | AA-1238 | C |  | AA-1235 | text2 | V |  |  |  | AA-1235 | text2 | V
AA-1236 | text3 | PI |  | 123458 | Text113 | AA-1238 | C |  | AA-1236 | text3 | PI |  |  |  | AA-1236 | text3 | PI
AA-1237 | text4 | I |  | 123459 | Text114 | AA-1238 | C |  | AA-1237 | text4 | I |  |  |  | AA-1237 | text4 | I
AA-1238 | text5 | A |  | 123460 | Text115 | AA-1238 | C |  | AA-1238 | text5 | A | 123456 | Text111 |  | AA-1238 | text5 | A | 123456 | Text111
[NAME] | text6 | C |  | 123461 | Text116 | AA-1238 | C |  | AA-1238 | text5 | A | 123457 | Text112 |  |  |  |  | 123457 | Text112
AA-1240 | text7 | A |  | 123462 | Text117 | AA-1238 | C |  | AA-1238 | text5 | A | 123458 | Text113 |  |  |  |  | 123458 | Text113
AA-1241 | [NAME] | C |  | 123463 | Text118 | AA-1238 | C |  | AA-1238 | text5 | A | 123459 | Text114 |  |  |  |  | 123459 | Text114
AA-1242 | [NAME] | A |  | 123464 | Text119 | AA-1238 | C |  | AA-1238 | text5 | A | 123460 | Text115 |  |  |  |  | 123460 | Text115
AA-1243 | text10 | C |  | 123465 | Text120 | AA-1238 | C |  | AA-1238 | text5 | A | 123461 | Text116 |  |  |  |  | 123461 | Text116
AA-1244 | text11 | PI |  | 123466 | Text121 | [NAME] | C |  | AA-1238 | text5 | A | 123462 | Text117 |  |  |  |  | 123462 | Text117
AA-1245 | text12 | A |  | 123467 | Text122 | [NAME] | C |  | AA-1238 | text5 | A | 123463 | Text118 |  |  |  |  | 123463 | Text118
AA-1246 | text13 | C |  | 123468 | Text123 | [NAME] | C |  | AA-1238 | text5 | A | 123464 | Text119 |  |  |  |  | 123464 | Text119
AA-1247 | text14 | PI |  | 123469 | Text124 | [NAME] | C |  | AA-1238 | text5 | A | 123465 | Text120 |  |  |  |  | 123465 | Text120
AA-1248 | text15 | PI |  | 123470 | Text125 | [NAME] | C |  | [NAME] | text6 | C | 123466 | Text121 |  | [NAME] | text6 | C | 123466 | Text121
AA-1249 | text16 | A |  | 123471 | Text126 | [NAME] | C |  | [NAME] | text6 | C | 123467 | Text122 |  |  |  |  | 123467 | Text122
AA-1250 | text17 | C |  | 123472 | Text127 | [NAME] | C |  | [NAME] | text6 | C | 123468 | Text123 |  |  |  |  | 123468 | Text123
AA-1251 | text18 | A |  | 123473 | Text128 | [NAME] | C |  | [NAME] | text6 | C | 123469 | Text124 |  |  |  |  | 123469 | Text124
 |  |  |  | 123474 | Text129 | [NAME] | C |  | [NAME] | text6 | C | 123470 | Text125 |  |  |  |  | 123470 | Text125
 |  |  |  | 123475 | Text130 | [NAME] | C |  | [NAME] | text6 | C | 123471 | Text126 |  |  |  |  | 123471 | Text126
 |  |  |  | 123476 | [NAME] | [NAME] | C |  | [NAME] | text6 | C | 123472 | Text127 |  |  |  |  | 123472 | Text127
 |  |  |  | 123477 | Text132 | [NAME] | C |  | [NAME] | text6 | C | 123473 | Text128 |  |  |  |  | 123473 | Text128
 |  |  |  | 123478 | Text133 | [NAME] | C |  | [NAME] | text6 | C | 123474 | Text129 |  |  |  |  | 123474 | Text129
 |  |  |  | 123479 | Text134 | [NAME] | C |  | [NAME] | text6 | C | 123475 | Text130 |  |  |  |  | 123475 | Text130
 |  |  |  | 123480 | Text135 | [NAME] | C |  | [NAME] | text6 | C | 123476 | [NAME] |  |  |  |  | 123476 | [NAME]
 |  |  |  | 123481 | Text136 | [NAME] | C |  | [NAME] | text6 | C | 123477 | Text132 |  |  |  |  | 123477 | Text132
 |  |  |  | 123482 | Text137 | AA-1240 | C |  | [NAME] | text6 | C | 123478 | Text133 |  |  |  |  | 123478 | Text133
 |  |  |  | 123483 | Text138 | AA-1240 | C |  | [NAME] | text6 | C | 123479 | Text134 |  |  |  |  | 123479 | Text134
 |  |  |  | 123484 | Text139 | AA-1240 | C |  | [NAME] | text6 | C | 123480 | Text135 |  |  |  |  | 123480 | Text135
 |  |  |  | 123485 | Text140 | AA-1240 | C |  | [NAME] | text6 | C | 123481 | Text136 |  |  |  |  | 123481 | Text136
 |  |  |  | 123486 | Text141 | AA-1240 | C |  | AA-1240 | text7 | A | 123482 | Text137 |  | AA-1240 | text7 | A | 123482 | Text137
 |  |  |  | 123487 | Text142 | AA-1240 | C |  | AA-1240 | text7 | A | 123483 | Text138 |  |  |  |  | 123483 | Text138
 |  |  |  | 123488 | [NAME] | AA-1241 | C |  | AA-1240 | text7 | A | 123484 | Text139 |  |  |  |  | 123484 | Text139
 |  |  |  | 123489 | Text144 | AA-1241 | C |  | AA-1240 | text7 | A | 123485 | Text140 |  |  |  |  | 123485 | Text140
 |  |  |  | 123490 | Text145 | AA-1241 | C |  | AA-1240 | text7 | A | 123486 | Text141 |  |  |  |  | 123486 | Text141
 |  |  |  | 123491 | Text146 | AA-1241 | C |  | AA-1240 | text7 | A | 123487 | Text142 |  |  |  |  | 123487 | Text142
 |  |  |  | 123492 | Text147 | AA-1241 | C |  | AA-1241 | [NAME] | C | 123488 | [NAME] |  | AA-1241 | [NAME] | C | 123488 | [NAME]
 |  |  |  | 123493 | Text148 | AA-1241 | C |  | AA-1241 | [NAME] | C | 123489 | Text144 |  |  |  |  | 123489 | Text144
 |  |  |  | 123494 | Text149 | AA-1241 | C |  | AA-1241 | [NAME] | C | 123490 | Text145 |  |  |  |  | 123490 | Text145
 |  |  |  | 123495 | Text150 | AA-1241 | C |  | AA-1241 | [NAME] | C | 123491 | Text146 |  |  |  |  | 123491 | Text146
 |  |  |  | 123496 | Text151 | AA-1242 | C |  | AA-1241 | [NAME] | C | 123492 | Text147 |  |  |  |  | 123492 | Text147
 |  |  |  | 123497 | Text152 | AA-1242 | C |  | AA-1241 | [NAME] | C | 123493 | Text148 |  |  |  |  | 123493 | Text148
 |  |  |  | 123498 | Text153 | AA-1242 | C |  | AA-1241 | [NAME] | C | 123494 | Text149 |  |  |  |  | 123494 | Text149
 |  |  |  | 123499 | Text154 | AA-1242 | C |  | AA-1241 | [NAME] | C | 123495 | Text150 |  |  |  |  | 123495 | Text150
 |  |  |  | 123500 | Text155 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123496 | Text151 |  | AA-1242 | [NAME] | A | 123496 | Text151
 |  |  |  | 123501 | Text156 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123497 | Text152 |  |  |  |  | 123497 | Text152
 |  |  |  | 123502 | Text157 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123498 | Text153 |  |  |  |  | 123498 | Text153
 |  |  |  | 123503 | Text158 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123499 | Text154 |  |  |  |  | 123499 | Text154
 |  |  |  | 123504 | Text159 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123500 | Text155 |  |  |  |  | 123500 | Text155
 |  |  |  | 123505 | Text160 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123501 | Text156 |  |  |  |  | 123501 | Text156
 |  |  |  | 123506 | Text161 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123502 | Text157 |  |  |  |  | 123502 | Text157
 |  |  |  | 123507 | Text162 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123503 | Text158 |  |  |  |  | 123503 | Text158
 |  |  |  | 123508 | Text163 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123504 | Text159 |  |  |  |  | 123504 | Text159
 |  |  |  | 123509 | Text164 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123505 | Text160 |  |  |  |  | 123505 | Text160
 |  |  |  | 123510 | Text165 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123506 | Text161 |  |  |  |  | 123506 | Text161
 |  |  |  | 123511 | Text166 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123507 | Text162 |  |  |  |  | 123507 | Text162
 |  |  |  | 123512 | Text167 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123508 | Text163 |  |  |  |  | 123508 | Text163
 |  |  |  | 123513 | Text168 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123509 | Text164 |  |  |  |  | 123509 | Text164
 |  |  |  | 123514 | Text169 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123510 | Text165 |  |  |  |  | 123510 | Text165
 |  |  |  | 123515 | Text170 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123511 | Text166 |  |  |  |  | 123511 | Text166
 |  |  |  | 123516 | Text171 | AA-1242 | C |  | AA-1242 | [NAME] | A | 123512 | Text167 |  |  |  |  | 123512 | Text167
 |  |  |  | 123517 | Text172 | AA-1243 | C |  | AA-1242 | [NAME] | A | 123513 | Text168 |  |  |  |  | 123513 | Text168
 |  |  |  | 123518 | Text173 | AA-1245 | C |  | AA-1242 | [NAME] | A | 123514 | Text169 |  |  |  |  | 123514 | Text169
 |  |  |  | 123519 | Text174 | AA-1246 | C |  | AA-1242 | [NAME] | A | 123515 | Text170 |  |  |  |  | 123515 | Text170
 |  |  |  | 123520 | Text175 | AA-1249 | C |  | AA-1242 | [NAME] | A | 123516 | Text171 |  |  |  |  | 123516 | Text171
 |  |  |  | 123521 | Text176 | AA-1250 | C |  | AA-1243 | text10 | C | 123517 | Text172 |  | AA-1243 | text10 | C | 123517 | Text172
 |  |  |  | 123522 | Text177 | AA-1243 | C |  | AA-1243 | text10 | C | 123522 | Text177 |  |  |  |  | 123522 | Text177
 |  |  |  | 123523 | Text178 | AA-1245 | C |  | AA-1243 | text10 | C | 123527 | Text182 |  |  |  |  | 123527 | Text182
 |  |  |  | 123524 | Text179 | AA-1246 | C |  | AA-1243 | text10 | C | 123532 | Text187 |  |  |  |  | 123532 | Text187
 |  |  |  | 123525 | Text180 | AA-1249 | C |  | AA-1243 | text10 | C | 123537 | Text192 |  |  |  |  | 123537 | Text192
 |  |  |  | 123526 | Text181 | AA-1250 | C |  | AA-1243 | text10 | C | 123542 | Text197 |  |  |  |  | 123542 | Text197
 |  |  |  | 123527 | Text182 | AA-1243 | C |  | AA-1243 | text10 | C | 123547 | Text202 |  |  |  |  | 123547 | Text202
 |  |  |  | 123528 | Text183 | AA-1245 | C |  | AA-1243 | text10 | C | 123552 | Text207 |  |  |  |  | 123552 | Text207
 |  |  |  | 123529 | Text184 | AA-1246 | C |  | AA-1244 | text11 | PI |  |  |  | AA-1244 | text11 | PI
 |  |  |  | 123530 | Text185 | AA-1249 | C |  | AA-1245 | text12 | A | 123518 | Text173 |  | AA-1245 | text12 | A | 123518 | Text173
 |  |  |  | 123531 | Text186 | AA-1250 | C |  | AA-1245 | text12 | A | 123523 | Text178 |  |  |  |  | 123523 | Text178
 |  |  |  | 123532 | Text187 | AA-1243 | C |  | AA-1245 | text12 | A | 123528 | Text183 |  |  |  |  | 123528 | Text183
 |  |  |  | 123533 | Text188 | AA-1245 | C |  | AA-1245 | text12 | A | 123533 | Text188 |  |  |  |  | 123533 | Text188
 |  |  |  | 123534 | Text189 | AA-1246 | C |  | AA-1245 | text12 | A | 123538 | Text193 |  |  |  |  | 123538 | Text193
 |  |  |  | 123535 | Text190 | AA-1249 | C |  | AA-1245 | text12 | A | 123543 | Text198 |  |  |  |  | 123543 | Text198
 |  |  |  | 123536 | Text191 | AA-1250 | C |  | AA-1245 | text12 | A | 123548 | Text203 |  |  |  |  | 123548 | Text203
 |  |  |  | 123537 | Text192 | AA-1243 | C |  | AA-1245 | text12 | A | 123553 | Text208 |  |  |  |  | 123553 | Text208
 |  |  |  | 123538 | Text193 | AA-1245 | C |  | AA-1246 | text13 | C | 123519 | Text174 |  | AA-1246 | text13 | C | 123519 | Text174
 |  |  |  | 123539 | Text194 | AA-1246 | C |  | AA-1246 | text13 | C | 123524 | Text179 |  |  |  |  | 123524 | Text179
 |  |  |  | 123540 | Text195 | AA-1249 | C |  | AA-1246 | text13 | C | 123529 | Text184 |  |  |  |  | 123529 | Text184
 |  |  |  | 123541 | Text196 | AA-1250 | C |  | AA-1246 | text13 | C | 123534 | Text189 |  |  |  |  | 123534 | Text189
 |  |  |  | 123542 | Text197 | AA-1243 | C |  | AA-1246 | text13 | C | 123539 | Text194 |  |  |  |  | 123539 | Text194
 |  |  |  | 123543 | Text198 | AA-1245 | C |  | AA-1246 | text13 | C | 123544 | Text199 |  |  |  |  | 123544 | Text199
 |  |  |  | 123544 | Text199 | AA-1246 | C |  | AA-1246 | text13 | C | 123549 | Text204 |  |  |  |  | 123549 | Text204
 |  |  |  | 123545 | Text200 | AA-1249 | C |  | AA-1246 | text13 | C | 123554 | Text209 |  |  |  |  | 123554 | Text209
 |  |  |  | 123546 | Text201 | AA-1250 | C |  | AA-1247 | text14 | PI |  |  |  | AA-1247 | text14 | PI
 |  |  |  | 123547 | Text202 | AA-1243 | P |  | AA-1248 | text15 | PI |  |  |  | AA-1248 | text15 | PI
 |  |  |  | 123548 | Text203 | AA-1245 | P |  | AA-1249 | text16 | A | 123520 | Text175 |  | AA-1249 | text16 | A | 123520 | Text175
 |  |  |  | 123549 | Text204 | AA-1246 | P |  | AA-1249 | text16 | A | 123525 | Text180 |  |  |  |  | 123525 | Text180
 |  |  |  | 123550 | Text205 | AA-1249 | P |  | AA-1249 | text16 | A | 123530 | Text185 |  |  |  |  | 123530 | Text185
 |  |  |  | 123551 | Text206 | AA-1250 | C |  | AA-1249 | text16 | A | 123535 | Text190 |  |  |  |  | 123535 | Text190
 |  |  |  | 123552 | Text207 | AA-1243 | C |  | AA-1249 | text16 | A | 123540 | Text195 |  |  |  |  | 123540 | Text195
 |  |  |  | 123553 | Text208 | AA-1245 | C |  | AA-1249 | text16 | A | 123545 | Text200 |  |  |  |  | 123545 | Text200
 |  |  |  | 123554 | Text209 | AA-1246 | C |  | AA-1249 | text16 | A | 123550 | Text205 |  |  |  |  | 123550 | Text205
 |  |  |  | 123555 | Text210 | AA-1251 | C |  | AA-1250 | text17 | C | 123521 | Text176 |  | AA-1250 | text17 | C | 123521 | Text176
 |  |  |  | 123556 | Text211 | AA-1251 | C |  | AA-1250 | text17 | C | 123526 | Text181 |  |  |  |  | 123526 | Text181
 |  |  |  | 123557 | Text212 | AA-1251 | P |  | AA-1250 | text17 | C | 123531 | Text186 |  |  |  |  | 123531 | Text186
 |  |  |  |  |  |  |  |  | AA-1250 | text17 | C | 123536 | Text191 |  |  |  |  | 123536 | Text191
 |  |  |  |  |  |  |  |  | AA-1250 | text17 | C | 123541 | Text196 |  |  |  |  | 123541 | Text196
 |  |  |  |  |  |  |  |  | AA-1250 | text17 | C | 123546 | Text201 |  |  |  |  | 123546 | Text201
 |  |  |  |  |  |  |  |  | AA-1250 | text17 | C | 123551 | Text206 |  |  |  |  | 123551 | Text206
 |  |  |  |  |  |  |  |  | AA-1251 | text18 | A | 123555 | Text210 |  | AA-1251 | text18 | A | 123555 | Text210
 |  |  |  |  |  |  |  |  | AA-1251 | text18 | A | 123556 | Text211 |  |  |  |  | 123556 | Text211
 |  |  |  |  |  |  |  |  | AA-1251 | text18 | A | 123557 | Text212 |  |  |  |  | 123557 | Text212