title: how to merge two rows into one in spotfire?
body: <p>I am stuck at a point in spotfire wherein I need to transform the table (the one below)</p>
  
  <pre><code>ID  First name  last name
  1   Mark    
  1               Taylor
  2   Howard  
  2               Giblin
  </code></pre>
  
  <p>to (the table as shown here)</p>
  
  <pre><code>ID First Name Last Name 
  1  Mark       Taylor 
  2  James      Bond 
  </code></pre>
  
  <p>Could someone please help me out. Thanks for the help in advance!</p>