loading a matrix

[jartzh]

I have a list of employee training records (1 row per class) . I need to update a training matrix with has the employee as the row and the classes across the columns. How can I load the rows into the training matrix on sheet 2?

Example:

employee class

101 aa
101 bc
102 cc
103 ab
I want to load to a matrix on Sheet 2:
_______aa ab ac ba bb bc ca cb cc
101 ____ x _____________x
102 ___________________________x
103 ______x

ho boy this is tough to fomat this example. I will build a simple spreadsheet with the example:

Thanks, guys

[zbor]

How about Pivot table?

[zbor]

And for code for example you strugling with use CODE tags around your text

Please Login or Register  to view this content.

[jartzh]

Zbor,
I like the Pivot table idea.
I guess I would just have to add a dummy employee record for a class that noone had taken?

[zbor]

Yes, if you like to see it in table.

[jartzh]

Zbor,
Yes if a new class is created then all the employees would need to take it , so it would need to be on the matrix as a missing class. The dummy record will work fine

Thanks, that works.