Replacing Nulls with values from previous column

[Brett_Woodward]

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! 

[binu_acs · Accepted solution]

@Brett_Woodward