Text Join Question

[xaikus506]

Hello, I would like to ask if there is a possibility that the text join formula would set its delimiter per row and not per column? and I would also like to ask if its possible to concatenate the header in between the text join values?
Thanks!

 

[CyrusTheVirus]

Are you able to help out by providing a condensed version of the problem and solution? The snapshot doesn't say all that much.

 

[xaikus506]

Are you able to help out by providing a condensed version of the problem and solution? The snapshot doesn't say all that much.

Hi, Thanks for the reply, I manage to find a solution by concatenating your raw data then apply the textjoin formula