title: Google Sheets - Concatenate 2 rows across columns into 1 cell
body: <p>I'd like to achieve what's in the Desired Output column in the image below. I need to take what's in row 1 (id1, id2, etc.), add ":" to that, then concatenate it with the values under each of the Field columns, add "|" to each ID-Value pair, and get that all together into one cell. I need the formula to also work for empty cells, as the number of fields to concatenate together is dynamic.</p>
  
  <p>So far I've tried a big CONCATENATE formula in one cell, but I can only get it to work for as many non-blank cells as I include in the formula.</p>
  
  <p>Thanks in advance!</p>
  
  <p><a href="https://i.stack.imgur.com/66Phl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/66Phl.png" alt="enter image description here"></a></p>