MiSolution
New Member
- Joined
- May 9, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hoping someone can help...
I am combining two different worksheet tables in Excel. Both worksheet tables consist employee data, created by two different people. I have standardised the column headers, however for each individual employee there are two rows of information - some of the data is different, some is the same, some is missing in one but not in the other and so on. See the example below.
What I would like to do is have is clean and correct data for each employe in one row. Does anyone have a solution? (The example below is only a small example of the long list of employees and numerous columns of the actual worksheet tables that I am trying to combine. Thanking you in advance if you can help...
I am combining two different worksheet tables in Excel. Both worksheet tables consist employee data, created by two different people. I have standardised the column headers, however for each individual employee there are two rows of information - some of the data is different, some is the same, some is missing in one but not in the other and so on. See the example below.
What I would like to do is have is clean and correct data for each employe in one row. Does anyone have a solution? (The example below is only a small example of the long list of employees and numerous columns of the actual worksheet tables that I am trying to combine. Thanking you in advance if you can help...
