title: Merge into one row from two rows? (SQL Server)
body: <p>If I have code for example </p>
  
  <pre><code>SELECT DISTINCT 
      table1.column2, table2.column3, table2.column4 
  FROM 
      table1
  JOIN
      table2 ON table1.column = table2.column
  WHERE 
      table1.column1 IN ('Value1', 'Value2')
  </code></pre>
  
  <p>This will return two rows of the same data, except each one will have one value that is different for a specific column. How can I bring the one value over and just have it result in one column?</p>
  
  <p>for example it would currently result in something like this:</p>
  
  <pre><code>column1       column2        column3
  Value1        Value2         Value3
  Value1        Value2         Value5
  </code></pre>
  
  <p>Basically it creates two rows because in column 3, the  values are different, is there any way I can bring that value 5 and make a separate column for it into the first row?</p>
  
  <p>Would this involve pivoting or how could I go about in doing this?</p>
  
  <p>Thank you for any help!</p>