Hello,
So I'm currently working on a workflow where the result has to be two columns: account number, account name.
I have attached a sample file of what I'm currently working with. I have a Record ID column to track the each transaction so that the account number and name being pulled is from the same transaction number. The "Parse" column contains both the account numbers and names. The "Header" column just shows whether the current record in "Parse" is either an account number or account name.
Is there a way I can make the account number and account name their own column while taking the information from the "Parse" column and appending the information to the appropriate column?
Thank you
