Without seeing your query, it's impossible to tell what the best approach may be. The previous posts will certainly work, but it's entirely possible that your original query may be doing on unnecesary pivot or crosstab and removing that pivot/crosstab will solve your problem.

Drew