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 757 8,497.70
Updates SourceType=personnel, PersonnelID, and CustomName.
R8 752 8,497.82
Updates SourceType=personnel, PersonnelID, and CustomName.
天成包网 27 50,788.84
Updates SourceType=personnel, PersonnelID, and CustomName.
Unknown 6 -73,014.41
Updates SourceType=personnel, PersonnelID, and CustomName.
YADAV RAGHUBIR KUMAR(NEPAL) 5 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
NPR 22GROUP 4 1,417.00
Updates SourceType=personnel, PersonnelID, and CustomName.
RICHMOND的人 4 852.00
Updates SourceType=personnel, PersonnelID, and CustomName.
LOW KAR CHUN 3 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
CC 2 153.36
Updates SourceType=personnel, PersonnelID, and CustomName.
CHAN LEN YONG 2 139.99
Updates SourceType=personnel, PersonnelID, and CustomName.
S991 2 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
SIM KE HAN 2 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
TAN WEI SHI 2 139.99
Updates SourceType=personnel, PersonnelID, and CustomName.
NPR 1 10,000.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.