Monster of an SQL Puzzle

[Mayoor]

In my database of applicants I have the following fields.

Ethnicity(ethnicity1, ethnicity2 e.t.c), Gender(Male or Female) and Location (County1, County2 County 3 e.t.c)

I need to organise my query so that the data is produced in the following format

Ethnicity 1 Ethnicity 2 Ethnicity 3
Male Female Male Female Male Female
Location 1 2 3 4 5 6 7
Location 2 5 5 6 8 5 2
Location 3 3 3 3 3 3 6
Location 4
.
.
.

Can anyone help me with this monster of a SQL Puzzle

 

[jby1]

Why can't you just group the data and then sort out the display formatting in whatever application is used to view it?

 

[MDXer]

The layout of your desired result set is of a multidimensional result set, which is what olap is for. However you may be able to get close using the cube operator.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck