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 316 -68.24
Updates SourceType=personnel, PersonnelID, and CustomName.
R8 313 539.28
Updates SourceType=personnel, PersonnelID, and CustomName.
天成包网 10 23,311.00
Updates SourceType=personnel, PersonnelID, and CustomName.
RICHMOND的人 4 852.00
Updates SourceType=personnel, PersonnelID, and CustomName.
Unknown 4 -48,304.41
Updates SourceType=personnel, PersonnelID, and CustomName.
YADAV RAGHUBIR KUMAR(NEPAL) 4 1,589.50
Updates SourceType=personnel, PersonnelID, and CustomName.
LOW KAR CHUN 3 0.00
Updates SourceType=personnel, PersonnelID, and CustomName.
MILLE 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.
发发游乐城 1 100.00
Updates SourceType=personnel, PersonnelID, and CustomName.
發發娱乐城 1 900.00
Updates SourceType=personnel, PersonnelID, and CustomName.