title: Concatenate entries from all incomplete rows with entries in complete rows above them
body: <p>I converted a few files containing huge price lists from *.pdf to *.xls format using an online file format converter. However the conversion didn't give the desired result and more cleanup work is needed on the file. Have tried various different approaches using the macro recorder and tack overflow and have failed. </p>
  
  <p>I need a macro that does the following cleanup work on my data.</p>
  
  <ol>
  <li>Loops through rows in the selected data and Search for incomplete rows that are missing an entry in one or more cells.</li>
  <li>Concatenate the text in these incomplete rows with the cell in the same column in the first complete row above it.</li>
  </ol>
  
  <p>Example;</p>
  
  <p>If row A contains all entries, but row B is missing entry in the Product code column then the entry in the needle description column in row B should concatenate with the needle description in row A </p>
  
  <p>This file contain 10 line of data. Tab 1 shows the data that contains incomplete rows for the first 2 products. Tab 2 shows the form i want it to be in. </p>
  
  <p><a href="http://www.filetolink.com/5e39eaaf00" rel="nofollow">http://www.filetolink.com/5e39eaaf00</a></p>
  
  <p>I'd be very grateful for any help on this for it will save me a lot of head wringing.</p>