How to put the values in different columns into one column in Excel?

I have 140 column that for each row only one of them have a string value and the rest are blank. What I need is to create one column to have all the values and for all rows. here is the example:

Here is what I have

Here is what I need

>Solution :

If one has it we can use TEXTJOIN which can ignore empty cells:

=TEXTJOIN("",TRUE,B2:E2)

Or without we can use INDEX/MATCH with wildcard:

=INDEX(B2:E2,MATCH("*",B2:E2,0))

Or even HLOOKUP:

=HLOOKUP("*",B2:E2,1,FALSE)

Or LOOKUP:

=LOOKUP(2,1/(B2:E2<>""),B2:E2)

Or XLOOKUP:

=XLOOKUP("*",B2:E2,B2:E2,"",2)