Assign Other Name to Personnel ID

Group mode: each row is one current Other name (e.g. TAN SUK AI). Assign once to map all rows with that name to a Personnel ID and rename to that personnel's main name.
Current Other Name Count Total Amount Assign to Personnel
V9k 947 1,011.09
Updates SourceType=personnel, PersonnelID, and CustomName.
R8 941 1,011.21
Updates SourceType=personnel, PersonnelID, and CustomName.
KL 84 -0.01
Updates SourceType=personnel, PersonnelID, and CustomName.
KUCHING 73 0.49
Updates SourceType=personnel, PersonnelID, and CustomName.
NPR 32 171,873.27
Updates SourceType=personnel, PersonnelID, and CustomName.
天成包网 27 50,788.84
Updates SourceType=personnel, PersonnelID, and CustomName.
Galaxy8 24 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
MILLE 20 -25,000.00
Updates SourceType=personnel, PersonnelID, and CustomName.
PGK 15 681.56
Updates SourceType=personnel, PersonnelID, and CustomName.
Unknown 7 -78,448.41
Updates SourceType=personnel, PersonnelID, and CustomName.
AA 5 1,439.95
Updates SourceType=personnel, PersonnelID, and CustomName.
RICHMOND的人 5 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
YADAV RAGHUBIR KUMAR(NEPAL) 5 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
CC 3 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
CHAN LEN YONG 3 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
LOW KAR CHUN 3 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
TAN WEI SHI 3 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
Little Trading Starting Balance 2 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
S991 2 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
SAWADDEE STARTING BAL 2 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
SIM KE HAN 2 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
发发游乐城 1 100.00
Updates SourceType=personnel, PersonnelID, and CustomName.
發發娱乐城 1 900.00
Updates SourceType=personnel, PersonnelID, and CustomName.