Split one field based on another

[swiles]

Hello,

I have data that I need new fields created based on the value in one field. If the value in the “isEnding” field is TRUE, then I need the amount to go to a new field “Ending”. If the value in “isEnding” is FALSE, then I need the amount to go to a new field “Beginning”. Attached is an Excel file with two worksheets, the Input and the desired output.

Thanks in advance for any suggestions!

Scott

[ChrisTX · Accepted solution]

Use the Formula tool to create two new fields

Beginning formula   If [isEnding] = 0 Then [Amount] else Null() Endif

Ending formula   If [isEnding] = 1 Then [Amount] else Null() Endif