Hi Everyone,
I am having a hard time trying to figure out a solution for my below attached query.
In the attached excel workbook below on 1st sheet, column "A" stores the data for different sales offices and there are multiple employees assigned to most of the sales offices.
My requirement: is to fetch the data from Sheet 2 to Sheet 1, have the name of employees to their respective sales office and since most of the sales offices occurs more than once the employee name should not be repeated.
For example Atlanta has 2 employees and on sheet 1 Atlanta appears twice so both should have a separate name just as provided on Sheet 2.
I have added the result the way it should look on Sheet 1 only.
Can anyone please suggest something.
Thank You in advance
Regards
I am having a hard time trying to figure out a solution for my below attached query.
In the attached excel workbook below on 1st sheet, column "A" stores the data for different sales offices and there are multiple employees assigned to most of the sales offices.
My requirement: is to fetch the data from Sheet 2 to Sheet 1, have the name of employees to their respective sales office and since most of the sales offices occurs more than once the employee name should not be repeated.
For example Atlanta has 2 employees and on sheet 1 Atlanta appears twice so both should have a separate name just as provided on Sheet 2.
I have added the result the way it should look on Sheet 1 only.
Can anyone please suggest something.
Thank You in advance
Regards