title: How to reorganise a table basis a criteria
body: <ol>
  <li>I have a table where columns exist at different rows as shown in Problem figure. </li>
  <li>I am able to identify the rows of column headers (Numbered 1 in column A) and there values(Numbered 2,3 onwards in Column A). </li>
  <li>I want collate it in a neat table as shown in Solution table; where all Column headers are in one row and subsequently we have their values.</li>
  </ol>
  
  <p>Problem and expected results are as shown in picture
  <a href="https://i.stack.imgur.com/wGJ5G.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wGJ5G.png" alt="enter image description here"></a></p>