Merging Results in 1 Column

[ubaps]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Base[/TD]
[TD]FINAL STATUS[/TD]
[TD]DATA 1[/TD]
[TD]DATA 2[/TD]
[TD]DATA 3[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD][/TD]
[TD]ok[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD]no[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]sample[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD][/TD]
[TD][/TD]
[TD]no[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Based on the table above. I would like to know how can I merge the data from columns DATA 1 to DATA 3 into the FINAL STATUS column. Like the TABLE below.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Base[/TD]
[TD]FINAL STATUS[/TD]
[TD]DATA 1[/TD]
[TD]DATA 2[/TD]
[TD]DATA 3[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]ok[/TD]
[TD]ok[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]no
[/TD]
[TD][/TD]
[TD]no[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]sample[/TD]
[TD][/TD]
[TD][/TD]
[TD]sample[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]no[/TD]
[TD][/TD]
[TD]no[/TD]
[/TR]
</tbody>[/TABLE]

Appreciate your response.

Thanks!

 

[Peter_SSs]

If they are text entries like your sample and there is just one entry per row, try this in A2, copied down
=LOOKUP(REPT("z",255),C2:E2)

Edit: If you have the CONCAT() function in your Excel version:
=CONCAT(C2:E2)

 

[ubaps]

Thanks peter.

just wanted to understand what the "z" in the rept function do?

Actually there are 8 data columns with different texts in them.

 

[Peter_SSs]

just wanted to understand what the "z" in the rept function do?

The REPT() function creates a long string of "z"s. When the lookup function cannot find that in the range, it returns the last thing that it can find.

Actually there are 8 data columns with different texts in them.

If only one of those 8 columns in each row has data, then the function(s) will still work if you just expand the range C2:J2
If more than one column in the same row can have text, what result(s) do you want? Some examples like you gave in post #1 ?

Do you have the CONCAT function (Excel through Office 365)?