title: Is it possible to joining multiple row
body: <p>I am looking for a way to join two rows with same value (promo code in my case). So for example, I have a table:</p>
  <pre><code>ID  PROMO_CODE   PROMO_NAME   DESCRIPTION       LANGUAGE
  1   PC123        ABC          Desc in English   ENG
  2   PC123        CBA          Desc in Español   ESP
  </code></pre>
  <p>and I want the result like:</p>
  <pre><code>ID PROMO_CODE  PROMO_NAME_ENG  PROMO_NAME_ESP  DESCRIPTION_ENG   DESCRIPTION_ESP
  1  PC123       ABC             CBA             Desc in English   Desc in Español
  </code></pre>
  <p>Any help will be appreciate</p>