In a messy report I need to get into 1 row customer code and the invoice.
Customer code is in the column 1, row 3. Invoice number is in column 2, row 1.
So basically question is, how can I fill the customer code upwards, not down?
Use the “Enumerate rows” action to enumerate rows. Then sort them in descending order. Apply the “Fill down” action. Sort rows back in the ascending order.
This worked well, thanks for the prompt help!