title: Create a single column of an Excel table (zeroes excluded)
body: <p>I have an Excel table.</p>
  
  <p>And I need to write its data into a single column, row by row, every row is "read" from left to right, zeroes excluded. Please look at the picture to understand better:</p>
  
  <p><a href="https://i.stack.imgur.com/KR0Th.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KR0Th.png" alt="What I have and what I need to get"></a></p>
  
  <p>Is there a way to do it quickly using VBA? I tried using only formulas and it worked, but it took several steps (creating a column, excluding zeroes, re-writing the column...) and really slowed down the whole process.</p>