I have this employee training sop matrix which indicate the required sop training that employee has to attend.
I like to know, how can i convert this matrix to a smarter database so i can apply those cool dynamic array staff such as filtering, pivot table.
My main goal is to to be able to apply a dynamic filtering formula to filter a particular employee and see the overall training that this person need or maybe a specific training sop to see which employee that are required to attend.
Bookmarks