title: Concatenate cells in column based on criteria
body: <p>I am looking to concatenate cells in a column. the model begins with a model number without any <code>.</code> the options to that model begin with <code>.</code> I would like the marco to concatenate all the way until the beginning of the next model number (the next cell that does not begin with <code>.</code>) , then repeat process, I have provided a an example below. Any help would be greatly appreciated! </p>
  
  <p><strong>current State</strong></p>
  
  <pre><code>abc
  
  .bcr
  
  .kjl
  
  .plk
  
  ghy
  
  .ytr
  
  .ihgew
  
  .rth
  
  .u
  
  .lpn
  
  trh
  
  .pjkjh
  
  .dsgyudd
  
  .hg
  
  .gfd
  </code></pre>
  
  <p><strong>Future State</strong></p>
  
  <pre><code>abc.bcr.kjl.plk
  
  ghy.ytr.ihgew.rth.u.lp
  
  trh.pjkjh.dsgyudd.hg.gfd
  </code></pre>