Separating a column by debits and credits

[bryce_bollinger2024]

Hello,

I have transposed a data set, selecting the fields that I wanted to stack on top of one another. However, from this transpose, there are specific columns that I would like to create two separate columns for - namely debits and credits. I cannot figure out how to do this without hard coding the different columns into their separate places, and I would love to learn of a tool that would allow me to separate out these different fields by debits and credits. Each field is marked with names, now I just need to be able to separate the debits from the credits in different columns.

Any help is much appreciated!

[abe_ibanez · Accepted solution]

Hello, 
I would probably use the Multi-Row Formula. If you use two of them, (one for your credits and one for your debits), you can use an if/then formula within each of them to separate the incoming fields into two separate ones. 

Then you can use a select tool to drop the column you no longer need. 

Hope this helps.