title: Excel spreadsheet - combine rows in column 1 and 2, 3 and 4 and so on
body: <p>The only way my client can provide me these addresses is with the location is in one row: Location Name, street address, city.....and then the row below it contains the zip code. This repeats for 1600 lines. </p>
  
  <p>I, of course, need all the info on one line. Is there a genius out there than knows how to make short work of putting the zip code on the line above it?</p>
  
  <p><a href="https://i.stack.imgur.com/BAhz2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BAhz2.png" alt="enter image description here"></a></p>