I taught myself coding, I understand most of the coding logics, but this one really got me. I hope you can help shed some light as I'm getting desperate!
I'm working on a staff directory.
Current situation:
Staffs are grouped under categories.
Some staffs appear in more than one category.
The challenge:
Staffs are order according to their ranking under a given category.
However, several staffs may be in different order under different category.
For example:
Under Dept A, we have...
Adele
Betty
Charlie
Under Dept B, we have...
Charlie
Dawn
Betty
Notice how Betty and Charlie has swapped position under different department?