title: Convert table data into flat format using of Excel VBA
body: <p>I have the following input data range</p>
  
  <p><img src="https://i.stack.imgur.com/VWblX.png" alt="Input range"></p>
  
  <p>and the following desired output</p>
  
  <p><img src="https://i.stack.imgur.com/fIV13.png" alt="Desired output"></p>
  
  <p>The first block with Compals will be always the same - so 5 rows. <strong>Base Unit Current</strong> and <strong>Base Unit Later</strong> blocks will be variable - sometimes eight options and sometimes more than eight options.</p>
  
  <p>I'm very new in excel vba so unfortunately I have no idea how to do that. Please, could anyone help me or give me some advice. Many thanks in advance.</p>