title: VBA transpose rows of data into columns
body: <p>I googled this question, but nothing reasonalbe didn't pop out, and i don't have any clue, at the moment, how to do it. So, decided to write here. </p>
  
  <p>I have large table, aprox. 300'000 rows, and between normal rows, i have some information, which needs to be transposed to rows. 
  As a sample, this information looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/XHfEB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XHfEB.png" alt="enter image description here"></a></p>
  
  <p>If any ideas pops out, please, let me know. 
  Best regards.</p>