=CONCATENATE(A1,"|",B1,"|",C1,"|",D1,"|",E1,"|",F1 )

"TamIam" wrote:

Good day!

I need a formula that I can use to take values in one row but different
columns and merge them together into one line with the pipe symbol (|)
separating the column values, for example:

Column:
A B C D E F

100 141 154 160 175 182

Becomes
Column
A B C D E F
100|141|154|160|175|185

I have been using the "&" function, but I can't seem to get the formula right.

--
Thanks for your help!