Forum Discussion

Gilson_Souza's avatar
Gilson_Souza
Frequent Visitor
4 years ago

Fill blank values based in the next/last value

Hi, everyone! I need some help, please. I need to fill the blank values with the next (or last) License Plate value:   This is what I have:   Date License Plate Value 01/07/2022 ABC12...
Need Help
marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
4 years ago

Hey Gilson_Souza ,

I think you should do this using fill down. But at first, you need to transform the blank values into null values, and after that, you can use the fill down option. 

 

*If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Regards,

Marcel Magalhães

 

 

 

  • Gilson_Souza's avatar
    Gilson_Souza
    Frequent Visitor
    4 years ago

    Hi, Marcel. Thanks for your help and sorry the delay, I was sick this week.

     

    I can't use fill down cause the first value of a particular car could be empty like this:



    10/07/2022ABC123C22
    01/07/2022CPC322 
    02/07/2022CPC322K99

     

    CPC322 can't have X22 values, only X99, so the filled value would be K99, not C22.