Hi. Can I get all the specific information I need in one master file? Here's a vague explanation of what I want to do.
File 1
File 2
Now what I want in the Master file is this:
Based on the information given Name, Fruit, Country, Phone, and Color, I want to know which file they came from.
File 1
Name | Fruit | Country | Phone | Color |
James Rick | Apple | Korea | 555 555 5555 | Red |
Terry Williams | Grapes | Malaysia | 444 444 4444 | Blue |
Steph Curry | Melon | Philippines | 333 333 3333 | Yellow |
File 2
| Fruit | Country | Phone | Color | |
Lebron James | Banana | USA | 111 111 1111 | Brown | |
Steph Curry | Melon | Philippines | 333 333 3333 | Yellow | |
Rick Walls | Strawberry | Russia | 222 222 2222 | Orange |
Now what I want in the Master file is this:
Based on the information given Name, Fruit, Country, Phone, and Color, I want to know which file they came from.
Name | Fruit | Country | Phone | Color | From |
James Rick | Apple | Korea | 555 555 5555 | Red | File 1 |
Terry Williams | Grapes | Malaysia | 444 444 4444 | Blue | File 1 |
Lebron James | Banana | USA | 111 111 1111 | Brown | File 2 |
Steph Curry | Melon | Philippines | 333 333 3333 | Yellow | File 1, File 2 |
Rick Walls | Strawberry | Russia | 222 222 2222 | Orange | File 2 |