Simple training matrix

[jartzh]

I have a sheet with a list of employees (with a job code for each. The job code defines which training classes are required. I have a training sheet which list the job code as the rows and the classes across the columns. There is an x if the class is required for that job code.

REAL simple. But I cant figure out a way to create a sheet containing which training is required for each employee.

I am sure that has been done a thousands times but my search retrieves complicated apps that are beyond my simple needs.

I can send an example if that would help visualize my project.

Thanks

[zbor]

Example with possible inputs and desired output would be nice.

[jartzh]

Sure, I have been working on it since the post and now have a sample to illustrate my question.
You can see Employees is on sheet 1, Training Matrix is on sheet 2, Training needs is on sheet 3.

So I have the employees on a sheet 3 displaying who needs what. but its not very pretty.
How can I list the training classes an employee needs in a form as on Employee report?
I have just typed them in in this example but I would like excel to generate it. The report basically removes the blank cells and fills in the names of the columns in the cell.