title: split row_number() over partition over multiple columns
body: <p>I have a query which uses row_number() over partition.
  When the result comes out it looks like</p>
  
  <pre><code>Product         Row_Number         Price
  A               1                  25
  A               2                  20
  A               3                  15
  B               1                  100
  B               2                  10
  B               3                  2
  </code></pre>
  
  <p>I want to get the result to show over columns like</p>
  
  <pre><code>Product      Row1         Row2        Row3      price1       price2       price3
  A            1            2           3         25           20           15
  B            1            2           3         100          10           2
  </code></pre>
  
  <p>Should I use something like rank()???</p>
  
  <p>I'm using Teradata</p>