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

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.