This is the type of output i was hoping to get but my formula doesn't seem to produce this. How'd i got about capturing this?
Company | Field 1 | Field 2 | Output |
A | AG | AG | AG |
B | AE | AE | |
C | BC | BC | |
D | ZY | ZY |
Thanks. i tried it and didn't work for me.
I have the following output
How can I help?
IIF(IsEmpty(Trim([Field 2])),[Field 1],IIF(IsEmpty(Trim([Field 1])),[Field 2],[Field 1]))