I need help with an Access query. I have a table in access with stacked data in the following format:
ID Unit Job Group Score
1 GA 1A Female 5
2 GA 1A Male 4
3 NC 5B Female 2
4 NC 5C Male 8

I need the query output to be formatted as follows:
Unit Job FemaleScore MaleScore
GA ...