title: excel sheet sub headings as columns
body: <p>I am totally new to this kind of challenges and not sure any thing available ( not sure even on what base I have to search ) </p>
  
  <p>In the below excel sheet image the column 'A' has headings in two places ( row numbers 2,3 and 9,10) . The actual excel sheet has more than six thousand rows and too many sub headings like this ( If it is small file I can do it manually.. but more than 6 thousand rows) </p>
  
  <p>The challenge :- I want to populate E column with "Make" value and F column with " Model" from sub headings . Can I write any rule or macro to populate these columns ? could some one help me ? Thanks for your help </p>
  
  <p><a href="http://imageshack.us/photo/my-images/850/81362269.png/" rel="nofollow noreferrer">Image Link </a></p>
  
  <p>or below</p>
  
  <p><img src="https://i.stack.imgur.com/MiFdo.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/WC2Ud.png" alt="enter image description here"></p>
  
  <p>Regards</p>
  
  <p>Kiran</p>