title: Concatenate varying number of rows in one column by one keyword in Excel
body: <p>Can you help me understand how to Concatenate all rows of a bunch of records in one column, but with varying numbers of rows and delineated by a keyword indicating the first row like 'File*#' ?  An example:</p>
  
  <pre><code>1   file# x  stuff...  
  2   more stuff  
  3   more stuff.   
  4   file# x   stuff...  
  5   more stuff  
  6   File #    stuff  
  7   File#   stuff
  </code></pre>
  
  <p>Thank you!</p>