Spreadsheet: 845262d1696794840-power-query-more-efficient-way-to-label-rows-with-duplicate-key-information-example1
Sheet: OutPut

 |  |  |  |  |  |  |  |  |  | Custom to identify duplicate "Helper" entries
Code | Date | ID | EIN | CIty | Name | Time | [NAME] | Hours | Username | Helper | Custom
HID | 2023-06-03 00:00:00 | 230119468-X | 96-9707576 | Weihai | [NAME] | 10:31 PM | [EMAIL] | 28.6 | hmiklem0 | hmiklem006/03/2023 | no
BKB | 2023-05-05 00:00:00 | 271550696-1 | 40-8483444 | Amiens | [NAME] | 8:09 PM | [EMAIL] | 45 | cfoynes1 | cfoynes105/05/2023 | no
EPT | 2023-04-16 00:00:00 | 766059511-3 | 06-4180911 | Galapa | Priscilla Elam | 7:29 PM | [EMAIL] | 24.1 | pelam2 | pelam204/16/2023 | no
ADG | 2023-02-22 00:00:00 | 612948106-3 | 10-4425904 | [NAME] | Violet Krauss | 12:08 AM | [EMAIL] | 47 | vkrauss3 | vkrauss302/22/2023 | Yes
AMZ | 2023-04-26 00:00:00 | 335241251-0 | 48-4016188 | [NAME] | Cathe Castella | 5:26 PM | [EMAIL] | 43.9 | ccastella4 | ccastella404/26/2023 | Yes
[NAME] | 2023-01-10 00:00:00 | 112960254-0 | 21-0092013 | [NAME] | [NAME] | 11:46 PM | [NAME] | 50.1 | khutfield5 | khutfield501/10/2023 | Yes
SOH | 2023-05-09 00:00:00 | 296559596-1 | 74-4910203 | San Isidro | [NAME] | 4:47 AM | [EMAIL] | 58.9 | slightwing6 | slightwing605/09/2023 | Yes
CXJ | 2023-06-05 00:00:00 | 783797638-X | 23-4405521 | El Limon | [NAME] | 3:03 AM | [EMAIL] | 57.2 | [NAME] | tmeace706/05/2023 | Yes
LSZ | 2023-03-02 00:00:00 | 015567101-4 | 92-0044135 | Longmen | Peadar Rolse | 1:56 AM | [EMAIL] | 57.2 | prolse8 | prolse803/02/2023 | no
PCA | 2023-01-07 00:00:00 | 397367781-6 | 87-5423422 | Inglewood | Henryetta Burbidge | 8:10 AM | [EMAIL] | 55.7 | hburbidge9 | hburbidge901/07/2023 | no
CMI | 2023-06-14 00:00:00 | 269206803-3 | 18-2257473 | Shuinan | [NAME] | 4:15 PM | [EMAIL] | 55.6 | fcicchitelloa | fcicchitelloa06/14/2023 | no
PBM | 2023-01-15 00:00:00 | 050057056-6 | 98-1299991 | Maple Plain | Charo Sweeny | 2:59 AM | [EMAIL] | 47.8 | csweenyb | csweenyb01/15/2023 | no
BIE | 2023-05-23 00:00:00 | 056824888-0 | 77-2398843 | Castilla | [NAME] | 7:26 PM | [EMAIL] | 37.7 | mgutchc | mgutchc05/23/2023 | no
PPA | 2023-04-13 00:00:00 | 520222824-4 | 30-4762699 | Zlynka | Berty Cottisford | 9:39 AM | [EMAIL] | 22.5 | bcottisfordd | bcottisfordd04/13/2023 | no
SSD | 2023-02-22 00:00:00 | 612948106-3 | 10-4425904 | [NAME] | Violet Krauss | 4:05 PM | [EMAIL] | 47 | vkrauss3 | vkrauss302/22/2023 | Yes
CNG | 2023-04-26 00:00:00 | 335241251-0 | 48-4016188 | [NAME] | Cathe Castella | 11:44 AM | [EMAIL] | 43.9 | ccastella4 | ccastella404/26/2023 | Yes
CNB | 2023-01-10 00:00:00 | 112960254-0 | 21-0092013 | [NAME] | [NAME] | 4:04 AM | [NAME] | 50.1 | khutfield5 | khutfield501/10/2023 | Yes
ASD | 2023-05-09 00:00:00 | 296559596-1 | 74-4910203 | San Isidro | [NAME] | 12:08 PM | [EMAIL] | 58.9 | slightwing6 | slightwing605/09/2023 | Yes
QYD | 2023-06-05 00:00:00 | 783797638-X | 23-4405521 | El Limon | [NAME] | 3:53 PM | [EMAIL] | 57.2 | [NAME] | tmeace706/05/2023 | Yes
WSD | 2023-06-16 00:00:00 | 722951058-9 | 00-3271326 | Ivry-sur-Seine | Putnam Boggon | 12:18 PM | [EMAIL] | 49.5 | [NAME] | pboggonj06/16/2023 | no
LCM | 2023-02-17 00:00:00 | 107347884-X | 76-6705097 | Nampera | [NAME] | 2:29 AM | [EMAIL] | 48 | [NAME] | lsabattierk02/17/2023 | no
TNG | 2023-05-09 00:00:00 | 963588740-X | 15-2097306 | Aughrim | [NAME] | 5:10 AM | [EMAIL] | 41.6 | [NAME] | dmacscheriel05/09/2023 | no
PUW | 2023-04-22 00:00:00 | 737213528-1 | 39-1915611 | [NAME] | Far Rubinowitsch | 4:52 AM | [EMAIL] | 53.3 | frubinowitschm | frubinowitschm04/22/2023 | no
CVQ | 2023-03-05 00:00:00 | 840262935-0 | 21-3498779 | Kashar | [NAME] | 10:41 PM | [EMAIL] | 39.6 | gverginen | gverginen03/05/2023 | no