Formula

[fatihcilgin]

Hello,

I want to make this formula for horizontal change, is it possible ?

IF IsEmpty([Column Name])
THEN [Row-1:Column Name]
ELSE [Column Name]
ENDIF

For instance,   

 Column Name: A      B     C     D      E    F

                        100, null, null, 200, null, null,

these are my column name,  I want is to if B column is null or empty take data from column A. 

As a result I want to see "100" in column B.

[caltang]

Like so?

[fatihcilgin]

Yes I want like this and I know this method but ı am looking for easiest way, I thought that maybe there is a just one specific tool for this purpose. But thanks a lot

[caltang · Accepted solution]

The way I showed is the most dynamic as it takes in new columns. If your data is fixed, then you could use a formula tool, but the IF statement will be a nightmare. 

If it helps, kindly mark it as an accepted solution to close the thread. Thanks.

[flying008]

Hi, @fatihcilgin 

Maybe you can building a UDF tool for your requirement by yourself.

Case: If the selected fileds [C] and [F] are null, then return value of left 2nd column. (Like [A] and [D])

******

Due to security policies, I am unable to upload any .yxm* files. So you need DIY.