title: SQL Query combine two rows into one row of data
body: <p>I have a table (see the image below --red box). It describes the content of my table (A, B, C, and D) are the columns.  The data structure will always be like this, if col A is Type_1, only col B has a content while if Col A is Type_2, Col C and D has contents while col B is NULL.</p>
  
  <p>Now, the table which re enclosed with green box is my desired output.</p>
  
  <p><img src="https://i.stack.imgur.com/LEFiG.png" alt="enter image description here"></p>
  
  <p>My experience on building a select statement is not very extensive and I'm almost leaning towards creating two separate tables to get my desired result (like 1 table for Type_1 data only and another table for Type_2 data only).</p>
  
  <p>Question is, is it possible to query two rows and combine it to become a single output result using SELECT query?  Considering that these two rows are on the same table?</p>
  
  <p>Thanks.</p>