title: Concatenate every other row in Excel
body: <p><strong>I have an Excel sheet that looks like this:</strong></p>
  
  <pre><code>3  | latitude | 46.142737
  
  3  | longitude| -57.608968
  
  8  | latitude | 43.142737
  
  8  | longitude| -52.608968
  
  15 | latitude | 41.142737
  
  15 | longitude| -59.608968
  </code></pre>
  
  <p><strong>I need the end result to look like this:</strong></p>
  
  <pre><code>3  | 46.142737, -57.608968
  
  8  | 43.142737, -52.608968
  
  15 | 41.142737, -59.608968
  </code></pre>
  
  <p>It can be concatenated based on every other row, or based on the integer value in the first column. </p>
  
  <p>VBA suggestions? Thank you.</p>
  
  <p>Edit: There is no actual "|" in my Excel sheet. The "|" is meant to be a visual cue representing a new column.</p>