SQL 2008 Columns to Rows

I have some code that I recieved help on from EE but I have one more questions concerning this code.  How would I convert the columns to rows.  This seems to be an eaiser format when using with DetailsView or in Pie Charts.  I am thinking that it probably involves a Pivot or Unpivot but I'm not sure exactly how to go about attaing the desired results.  I've attached the query below.

Thanks!

SELECT income
FROM client
WHERE ISNUMERIC(income) = 1

-- This returns counts for multiple ranges
SELECT
      COUNT(CASE WHEN a.income BETWEEN 0 AND 150 THEN a.income END) as count_0_150,
      COUNT(CASE WHEN a.income BETWEEN 151 AND 300 THEN a.income END) as count_151_300,
      COUNT(CASE WHEN a.income BETWEEN 301 AND 450 THEN a.income END) as count_301_450,
      COUNT(CASE WHEN a.income BETWEEN 451 AND 600 THEN a.income END) as count_451_600
FROM (
      SELECT CAST(income as numeric) as income
      FROM client
      WHERE ISNUMERIC(income) = 1
	  ) a 

Select all Open in new window