Hi, I have data in the following format policy_id,lst_renew_date,small_area 101,20180507,00011 102,20160508,00022 102,20170508,NULL 102,20180509,00022 103,20160510,00033 103,20170511,00033 103,20180511,NULL I want to clean the data so that every policy_id has a small_area code where possible. How could I go about creating replacing the NULL values for small_area with the most recent small_area code for that that policy_id? Regards Finbar
... View more