Create columns from result values

[Callum Macdonald]

Hi There,

I've got a query running which displays a list of user actions and the number of users which have completed each action, grouped by their referral code. The output is along the following lines:
Count | Action | Referral
1 | View | Google
2 | Download | Yahoo
etc

However, I'd like to format the data with a separate column for each of the Referral results, and a row for each action and value against each referrer. The output would like like:
Action | Google | Yahoo
View | 1 | 0
Download | 0 | 2
etc

Is that possible? How would I go about it?

Many thanks,


Callum.