I am trying to merge 2 fields if the second field is not empty. Excel function is: =IF(B1<>"",A1&" & "&B1,A1)
|Header 1||Header 2||Header 3|
|John||Jane||John & Jane|
My fields names to merge are: ClientFirstName (A1) and SpouceFirstName (B1) (as expressed in Excel formula)
Thanks for any suggestions.