title: Combining Columns in a Lotus Notes View
body: <p>Is there an equivalent of GROUP BY statement in a Lotus Notes view?</p>
  
  <p>Currently my table is laid out like this:</p>
  
  <pre><code>| JOB # | SHIP DATE 1 | MODULE 1 | SHIP DATE 2 | MODULE 2 |
  | 111   | APRIL 2013  |  123-XYZ |  APRIL 2013 | 654-ABC  |
  </code></pre>
  
  <p>to this (/ stands for a twistie):</p>
  
  <pre><code>\/|SHIP DATES|
      |MODULE 1|
      |MODULE 2|
  </code></pre>
  
  <p>The final output would look something like:</p>
  
  <pre><code>\/|April 2013|
      123-XYZ (this record would be from MODULE 1)
      654-ABC (this record would be from MODULE 2)
  \/|June 2013|
      876-DEF (this record is from MODULE 1, since there is no ship date for MODULE 2 in this month/year only one job appears)
  </code></pre>
  
  <p>Is there any way I could merge the ship date columns together?</p>