title: Transpose Rows to Columns for the same ID
body: <p>I have table called  equipment.</p>
  
  <blockquote>
    <p> Unit_ID &nbsp; SensorSerial <br/> 1 
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11 <br/> 1
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  22 <br/>
    1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  33
    <br/> 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
    44 <br/> 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
     55 <br/> 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;  66 <br/> 3 &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp;  77 <br/> 3 &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp;  88 <br/> 3 &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp;  99 <br/><br/></p>
  </blockquote>
  
  <p>I would like to make query to have following table: <br/><br/></p>
  
  <blockquote>
    <p>Unit_ID &nbsp; Sensor1 &nbsp; Sensor2
    &nbsp; Sensor3<br/> 1 &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp;&nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;22 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;33<br/> 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;&nbsp; 44&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;55 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;66<br/> 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;&nbsp; 77&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;88 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp;99<br/><br/></p>
  </blockquote>