Hi.
I'm currently trying to work out how to eradicate the nulls in a table using the values from the column to the left.
Current input (from external provider) looks like below:
| Commodity | Period 1 | Period 2 | Period 3 | Period 4 |
| abc | £0.46 | £0.47 | £0.48 | |
| def | £0.70 | £0.70 | £0.70 | £0.68 |
| ghi | | £0.74 | £0.70 | £0.69 |
| jkl | | £0.66 | £0.63 | £0.65 |
| mno | £0.66 | £0.72 | £0.74 | £0.84 |
| pqr | £0.73 | | | £0.71 |
| stu | £0.87 | £0.94 | £0.92 | £0.94 |
Using Data Cleansing, I've been able to update the Period 1 price to 0, however, I'm hoping to update the blank fields with the previous period price for the commodity.
EG:
| Commodity | Period 1 | Period 2 | Period 3 | Period 4 |
| abc | £0.46 | £0.47 | £0.48 | £0.48 |
| def | £0.70 | £0.70 | £0.70 | £0.68 |
| ghi | £0.00 | £0.74 | £0.70 | £0.69 |
| jkl | £0.00 | £0.66 | £0.63 | £0.65 |
| mno | £0.66 | £0.72 | £0.74 | £0.84 |
| pqr | £0.73 | £0.73 | £0.73 | £0.71 |
| stu | £0.87 | £0.94 | £0.92 | £0.94 |
Thanks!
