Need help to auto fill data

[Jumat73]

Please help to auto fill data from many columns to 1 column as below.

[#2]

@Jumat73 You need TEXTJOIN() function. Try-

=TEXTJOIN("-",1,A2:E2)