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.
Solved! Go to Solution.
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
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.
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.