6 Replies Latest reply: Dec 19, 2017 7:55 AM by Shane Spencer RSS

    Filling in blank records (peek/previous/above)

    Shane Spencer

      Please see the below sample data. Sometimes the GOODS_COUNTRY field is empty. If the GOODS_COMMODITY_CODE is the same as the record above only I want to use the above country. That would mean that records 14-17 would be SE however 25 and 26 would remain null as the commodity code above (record 21 is different). PFA the sample data in spreadsheet. Can anyone offer advice please? (What I've done using filters fills in all blanks without taking in to account the commodity code)