I have a table with transactions.
The columns are:
trxid is sequential transaction ID although with gaps here and there.
Split is either blank or S. S is for when a row is the sum of following rows.
The problem is that the row which has S has date and the payee and the amount, while the following component transactions only have the amounts but no date or payee.
What I want to do is go through the table and fill in the empty date and payee where missing with the date and payee of the preceding row with the S entry in the split column.
So as you can see, trxid 2 and 3 are missing date and payee and they need to be the same date and payee as trxid 1.
Same things with trxid 9 and 10 inheriting date and payee of trxid 8.
Hope this is clear.
I have tried and failed so your help will be much appreciated.