title: T-SQL Transposing column headers into Rows
body: <p>I want to transpose my table.
  I have simple 'Person' table as shown below. </p>
  
  <pre><code>+---+----------+------------+------------+----------------------+
  |ID | Person   | BirthDate  | Phone      | Email                |
  +---+----------+------------+------------+----------------------+
  | 1 | Tom      | 1985-11-08 | 1111111111 | tom@somedomain.com   |
  +---+----------+------------+------------+----------------------+
  | 2 | Dick     | 1982-02-24 | 2222222222 | dick@otherdomain.com |
  +---+----------+------------+------------+----------------------+
  | 3 | Harry    | 1986-04-17 | 3333333333 | harry@thatdomain.com |
  +---+----------+------------+------------+----------------------+
  </code></pre>
  
  <p>And I want this table to be transposed like below.</p>
  
  <pre><code>+-----------+--------------------+----------------------+----------------------+
  | Key       | Value1             | Value2               | Value3               |
  +-----------+--------------------+----------------------+----------------------+
  | ID        | 1                  | 2                    | 3                    |
  +-----------+--------------------+----------------------+----------------------+
  | Person    | Tom                | Dick                 | Harry                |
  +-----------+--------------------+----------------------+----------------------+
  | BirthDate | 1985-11-08         | 1982-02-24           | 1986-04-17           |
  +-----------+--------------------+----------------------+----------------------+
  | Phone     | 1111111111         | 2222222222           | 3333333333           |
  +-----------+--------------------+----------------------+----------------------+
  | Email     | tom@somedomain.com | dick@otherdomain.com | harry@thatdomain.com |
  +-----------+--------------------+----------------------+----------------------+
  </code></pre>
  
  <p>I am using MS SQL server 2008 R2.</p>