Forum Discussion
Concat Values In Same Column
Afternoon Excel Community, I'm currently trying to concat two cells in the same column (It's like this due to an output from a software where use). The column is formatted to where the cell below...
This is a 365 solution.
= LET(
Join, LAMBDA(x, TEXTJOIN("|",,x)),
BYROW(WRAPROWS(input,2), Join)
)