title: Transpose Table with information
body: <p>I need to transpose this view (in sql) </p>
  
  <p><a href="https://i.stack.imgur.com/kijuX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kijuX.png" alt="enter image description here"></a></p>
  
  <p>into this view: </p>
  
  <p><a href="https://i.stack.imgur.com/19cHX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/19cHX.png" alt="enter image description here"></a></p>
  
  <p>any solutiion?</p>