if column blank then take value from previous column

[Varan_15]

Hi All,

I have four columns for i need last column value if it's blank then it should take from previous column value like that it should check all the columns untill to get values.. Example like below 

incase all the columns are blank then result blank only. please help

[Varan_15]

Thanks Amit,

working as expected 

[amitchandak · Accepted solution]

@Varan_15 , A new column

=

coalesce([Column4], [Column3], [Column2], [Column1])