title: Convert Column to row (pivot)
body: <p>i need to make the data in the column to be column head</p>
  
  <p>this is the current result from my query .. :</p>
  
  <p>select employee_id,reimbursement_type,SUM(amount) as [total amount],reimbursement_status from md_reimbursement
  group by employee_id,reimbursement_type,reimbursement_status</p>
  
  <p><a href="https://i.stack.imgur.com/EjWtU.png" rel="nofollow"><img src="https://i.stack.imgur.com/EjWtU.png" alt="enter image description here"></a></p>
  
  <p>and i want it to be like this :</p>
  
  <p><a href="https://i.stack.imgur.com/0tkud.png" rel="nofollow"><img src="https://i.stack.imgur.com/0tkud.png" alt="enter image description here"></a></p>
  
  <p>*just ignore the Status field</p>
  
  <p>so the data reimbursement_type to become a column head and it SUM each amount.</p>
  
  <p>i already tried using pivot but didnt get what i expected.</p>
  
  <p>thx</p>