I have a database that looks like this
1 Canada
2 Edmonton Alberta
3 Calgary Alberta
4 Toronto Ontario
5 United States
6 New York New York
7 Las Vegas Nevada
I need to move the single field to everything underneath it
1 Canada
2 Edmonton Alberta Canada
3 Calgary Alberta Canada
4 Toronto Ontario Canada
5 United States
6 New York New York United States
7 Las Vegas Nevada United States
any suggestions?
1 Canada
2 Edmonton Alberta
3 Calgary Alberta
4 Toronto Ontario
5 United States
6 New York New York
7 Las Vegas Nevada
I need to move the single field to everything underneath it
1 Canada
2 Edmonton Alberta Canada
3 Calgary Alberta Canada
4 Toronto Ontario Canada
5 United States
6 New York New York United States
7 Las Vegas Nevada United States
any suggestions?