fill missing data with conditions
I have a dt that has missing data that i need to fill from the same column.the table tells us the color shirt someone is wearing i have a name, the date he changed his shirt, the next date he will change his shirt, and the color of the shirt.my problem is that he doesnt change his shirt everytime he updates his data. if he doesnt change his shirt he writes "na".i need to switch all the "na" with t...