A
Alawi
I have two Excel sheets one is master roster of employees and the others
training courses( transactions file) taken by some of the employees. What I
want to generate a list that shows courses taken by each employees if any(in
the training sheet) and merge it in the roster sheet in fornt of each
employee.( some employees have several courses & each course appear as a row
in the Training sheet);i,e.
Roster:
Employee A number, name
Employee B number , name
Employee C number, name
Training Sheet:
Employee A number, name & course 1
Employee A number, name & course 2
Employee B number, name, course 4
Employee c number, name, course 1
Employee c number, name, course 2
Employee c number, name, course 4
Employee c number, name, course 7
so I need the result as follows:
Employee A number, name, course 1, course2
Employee C number, name, course 1, course 2, course 4, course 7
etc
I appreciate your suggestion
training courses( transactions file) taken by some of the employees. What I
want to generate a list that shows courses taken by each employees if any(in
the training sheet) and merge it in the roster sheet in fornt of each
employee.( some employees have several courses & each course appear as a row
in the Training sheet);i,e.
Roster:
Employee A number, name
Employee B number , name
Employee C number, name
Training Sheet:
Employee A number, name & course 1
Employee A number, name & course 2
Employee B number, name, course 4
Employee c number, name, course 1
Employee c number, name, course 2
Employee c number, name, course 4
Employee c number, name, course 7
so I need the result as follows:
Employee A number, name, course 1, course2
Employee C number, name, course 1, course 2, course 4, course 7
etc
I appreciate your suggestion