title: SQL combine two rows with common batch number into one line
body: <p>I have an Oracle SQL (select *) query that spools batch transactional information, the result of which outputs the main sender and receivers to different lines for the same transaction like below:</p>
  
  <pre><code>BATCH_NO    DATE      AMOUNT    SENDER_ACCT_NO  SENDER NAME RECEIVER_ACCT_NO    RECEIVER NAME   
  12345678    15-May-20   103.55  400001000        ENDCORP         (null) 
  12345678    15-May-20   34.55   400001000        (null)          78909909         JOHN SMITH
  12345678    15-May-20   44.00   400001000        (null)          78853229         HENRY FAGIL
  12345678    15-May-20   4.00    400001000        (null)          76849852        BENJAMIN HOOK
  12345678    15-May-20   21.00   400001000        (null)          72555099          FELIX MAGS
  12222222    16-May-20   1902.00 400000105       ZENDCORP          (null)
  12222222    17-May-20   1899.00 400000105        (null)          90333300          KEN GOTL
  12222222    18-May-20   3.00    400000105        (null)          90127765         JONES MAST
  </code></pre>
  
  <p>In this case, ENDCORP and ZENDCORP sent out batch payments of a total of 103.55 and 1902.00 to 4 and 2 clients respectively.  </p>
  
  <p>However, I would prefer my results to be in the form below: </p>
  
  <pre><code>BATCH_NO    DATE      AMOUNT    SENDER_ACCT_NO  SENDER NAME    RECEIVER_ACCT_NO        RECEIVER NAME
  12345678    15-May-20   34.55   400001000        ENDCORP        78909909                JOHN SMITH
  12345678    15-May-20   44.00   400001000        ENDCORP        78853229                HENRY FAGIL
  12345678    15-May-20   4.00    400001000        ENDCORP        76849852                BENJAMIN HOOK
  12345678    15-May-20   21.00   400001000        ENDCORP        72555099                 FELIX MAGS
  12222222    17-May-20  1899.00  400000105       ZENDCORP        90333300                  KEN GOTL
  12222222    18-May-20   3.00    400000105       ZENDCORP        90127765                 JONES MAST
  </code></pre>
  
  <p>I would appreciate guidance on how to formulate my query for this result</p>