Basically what I'm doing is sorting peoples information in just 1 row. It's so tiring in doing cut and paste if I'm doing 20,000 information in a sheet.
What I want to happen is to sort John Smith's other phone# (from The Philippines) and to put it on phone#2 and phone#3. Also John Smith's other phone# (from US) to phone#2 and 3.
This might be tricky because some people might have similar names all over the world and I dont want to mix their information. The only way to identify them (which is which) is through their address..
Example:
What I want to happen is to sort John Smith's other phone# (from The Philippines) and to put it on phone#2 and phone#3. Also John Smith's other phone# (from US) to phone#2 and 3.
This might be tricky because some people might have similar names all over the world and I dont want to mix their information. The only way to identify them (which is which) is through their address..
Example:
testfirstname | testsurname | testphone#1 | testphone#2 | testphone#3 | testaddress |
John | Smith | (000) 252-1618 | PHILIPPINES | ||
John | Smith | (000) 454-1617 | PHILIPPINES | ||
John | Smith | (000) 656-1619 | PHILIPPINES | ||
John | Smith | (222) 181-2222 | UNITED STATES OF AMERICA | ||
John | Smith | (222) 181-3333 | UNITED STATES OF AMERICA | ||
John | Smith | (222) 181-3333 | UNITED STATES OF AMERICA |