Forum Discussion
How to combine data from Tables with differing data
Is there a way to combine the 2 datasets in Excel, Using a field such as Email or Phone number, where ALL the data will be present?
Background: Recruiters are scheduled a number of areas via Squarespace, where they recruit new hires, and are able to update their status, managers of those areas are then required to take attendance of the hires that have attended their assigned orientation. As a part of the onboarding new hires are required to complete paperwork, and recruiters are only paid for hires that attend orientation and have their paperwork completed before hand.
Data for Hire status, orientation date, and attendance is recorded on squarespace but on boarding completion data is recorded on a separate CRM that does not record all the same data. the only fields the datasets have In common are:
First name, Last name, Phone Number, and Email.
Is there a way to combine the 2 datasets in Excel, Using a field such as Email or Phone number, where ALL the data will be present?
2 Replies
How can I merge two or more tables?
You can merge (combine) rows from one table into another simply by pasting the data in the first empty cells below the target table. The table will increase in size to include the new rows.
Create a relationship between tables in Excel
Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
hope to have helped with this information
I know I don't know anything (Socrates)
- That does Help, I am still relatively new to Excel, I will look into creating relationships, Thanks a Ton!
