I am doing a project that entails @15 excel files from different data sources. The data is however the same. There is a name, email, address etc and 2 fields of attributes- say an indicator of their expertise. There are duplicates in the names, emails, and attribute columns. There are also unique attributes that I want to keep. Example:
<tbody>
</tbody>
This is a simple join in a robust database- but I have never figured out a real solution in excel. I am fine with some sort of repetitive process, but I am going to need to do this same thing over and over in the future, and I need to think through the right way to approach this now, before I spend a lot of time messing around with it. Any and all help would be fantastic. WP
PS- is powerpivot likely to help here?
| File1 | ||||||
| Name | Category 1 | Category 2 | ||||
| Mary Smith | Mary@smith.com | Expert | ||||
| John Doe | JohnDoe@gmail.com | |||||
| Jane Bell | JaneBell@gmailcom | |||||
| File2 | ||||||
| Name | Category 1 | Category 2 | ||||
| Mary Smith | Mary @smith.com | Entrepreneur | Sponsor | |||
| Joe Jefferson | JaneB@gmail.com | |||||
| File2 | ||||||
| Name | Category 1 | Category 2 | ||||
| Mary Smith | Marysmith@gmail.com | Prospect | ||||
| Robert Jones | Robert@test.com | |||||
| Bill Roberts | JaneB@gmail.com | |||||
| File Desired | ||||||
| Name | Email 1 | Email 2 | Category 1 | Category2 | Catagory3 | Category 4 |
| Mary Smith | Mary@Smith.com | MarySmith@gmail.com | Expert | Entrepreneur | Sponsor | Prospect |
<tbody>
</tbody>
This is a simple join in a robust database- but I have never figured out a real solution in excel. I am fine with some sort of repetitive process, but I am going to need to do this same thing over and over in the future, and I need to think through the right way to approach this now, before I spend a lot of time messing around with it. Any and all help would be fantastic. WP
PS- is powerpivot likely to help here?
