title: Converting multiple rows to multiple columns
body: <p>This is with SQL server </p>
  
  <pre><code>ID       ID1      Days     Rank
  96972    1        2976     1
  96972    174      2976     2
  96972    173      2966     3
  96972    175      2966     4
  96972    176      2963     5
  96972    177      2961     6
  96972    178      2960     7
  96972    179      2952     8
  96972    180      2945     9
  96972    181      135      10
  </code></pre>
  
  <p>I did Rank column in the result set as below </p>
  
  <pre><code>row_number() OVER(Partition by id ORDER BY somedate)  AS TimeLineOrders
  </code></pre>
  
  <p>I would like show these results in single row as</p>
  
  <pre><code>Timeline1     Timeline2     TimeLine3     Timeline4    Timeline 10
  96972         ID1+Days      ID1+Days      ID1+Days     ID1+Days     ID1+Days
  </code></pre>
  
  <p>Can anyone help me please?</p>