title: Custom Formula to Concatenate Multiple Rows If Condition Met
body: <p>I'm having trouble writing a UDF for Sheets that would allow me to concatenate multiple rows of data into a single text field with a delimiter based on unique ID. I've seen examples of this for excel, but haven't been able to find a sheet's equivalent. Basically, I want to concatenate all values in B:B where B(i) = A(i) delimited by a comma or pipe or some other delimiter. </p>
  
  <p>Basically, I want to concatenate all values in B:B where B(i) = A(i) in a single cell delimited by a comma or pipe or some other delimiter.</p>