Hello
I have data imported to Alteryx with the following detail
| Account | Description | Debit | Credit |
| 966 | Called up share capital | | |
| /1 | Share capital | | 1 |
| 968 | Profit and loss account | | |
| /1 | Brought forward | 326102.3 | |
In the account column, where the detail is shown as "/1" i need to replace that with the data from the row above in each case. This affects multiple lines but in every case just requires that data to be replaced with the data from one row up in the same column.
It can also be different numbers such as "/2" or "/3", which isn't determined by the number above.
Is this something simple to do in Alteryx with a formula or tool im unaware of. The replace tools appear to require a second input showing what to replace the data with, which wouldn't work in my case.
