title: How to convert a long form table to wide form table in Excel?
body: <p>A picture is worth a thousand words. Let's say in one sheet I have the following table:</p>
  
  <p><img src="https://i.stack.imgur.com/h9CTH.png" alt="enter image description here"></p>
  
  <p>Using this information, I want to programatically generate the table like this(sort of un-melting the long table into the wide form) in another sheet:</p>
  
  <p><img src="https://i.stack.imgur.com/vaDhg.png" alt="enter image description here"></p>
  
  <p>How can you achieve this?</p>