Transpose Country and City in SQL Server
<p>I have a table with 2 fields Country and City. I want to transpose this to I have the Country field as my headers and each of the cities as fields under them.</p>

<p>When I use the code I supplied below I get the results, but with nulls</p>

<pre><code>SELECT
    CASE WHEN Country = 'USA' then City end as USA,
    CASE WHEN Country = 'India' then City end as India,
    CASE WHEN Country = 'UK' then City end as UK
FROM Country
</code></pre>

<p><a href="http://i.stack.imgur.com/8V57P.jpg" rel="nofollow">Result from code</a></p>

<p>My question is how do I get a result without nulls?</p>